Problems with XLSReadWriteII 3.0 and C++ Builder 2006

[Petsche]

Hi,

I downloaded the XLSReadWriteII 3.00.02 and installed it in that way as explained (Components -> Install Package).Additionally I added the path into Project->Options.

Unfortunately the compiler always comes up with three errors (E2347). Two errors are in the Cell2.hpp and one is in the Recordstoragechart2.hpp.

I do not know what could be the root cause for that problem.
Maybe someone can help me.

Many thanks in advance.

Best regards,

Andreas

[larsa]

Hello

Is there an error message text?


Lars Arvidsson

[Petsche]

Yes there is but it is in German:

[C++ Fehler] Cell2.hpp(198): E2347 Keine Entsprechung der Parameter in read mit Zugriffsspezifikation der Eigenschaft PTGS
[C++ Fehler] Cell2.hpp(316): E2347 Keine Entsprechung der Parameter in read mit Zugriffsspezifikation der Eigenschaft ArrayData
[C++ Fehler] Recordstoragechart2.hpp(79): E2347 Keine Entsprechung der Parameter in read mit Zugriffsspezifikation der Eigenschaft Data

Therefore I will try to translate it into English:

[C++ Error] Cell2.hpp(198): E2347 Parameter mismatch in read access
specifier of property PTGS
[C++ Error] Cell2.hpp(198): E2347 Parameter mismatch in read access
specifier of property ArrayData
[C++ Error] Recordstoragechart2.hpp(79): E2347 Parameter mismatch in read access specifier of Data

Andreas

[Petsche]

The error Message are linked to the follwing code lines:

In Cell2.hpp

Error: property PTGS; Line 198:

__property Sysutils::PByteArray PTGS = {read=FPTGS};

Error: property ArrayData; Line 316

__property Sysutils::PByteArray ArrayData = {read=FArray};

In RecordStorageChart.hpp

Error: property Data; Line 79

__property Sysutils::PByteArray Data = {read=FData};

Best regards,

Andreas

[larsa]

Hello

The error is probably related to previous versions that you have installed.
Please search your hard drive for these (search for xls*.*) and remove
all traces of previous versions.


Lars Arvidsson

[Dave_Scream]

Hi. I'm sorry but I have the same problem..

steps:
dl this:

Code: Select all

http://www.axolot.com/components/xlsrwii30_bds.exe

install it to:

Code: Select all

C:\Program Files\XLSReadWriteII30

in BSD2006 add package:

Code: Select all

C:\Program Files\XLSReadWriteII30\Package\BDS2006\XLSRWII30_BDS2006.bpl

open example project:

Code: Select all

C:\Program Files\XLSReadWriteII30\Samples\Builder\FindText\FindTextSample.bdsproj

going to: Project->Options->C++ Compiler->Paths and Defines->Include Search Path->Edit... and change pathes to my.

then i press Run...
and get the same errors:

Code: Select all

[C++ Error] Cell2.hpp(198): E2347 Parameter mismatch in read access specifier of property PTGS
[C++ Error] Cell2.hpp(312): E2347 Parameter mismatch in read access specifier of property ArrayData
[C++ Error] Recordstoragechart2.hpp(79): E2347 Parameter mismatch in read access specifier of property Data
[C++ Error] Main.cpp(47): E2096 Illegal structure operation
[C++ Error] Main.cpp(62): E2096 Illegal structure operation

first error is in file Cell2.hpp (line 198):

Code: Select all

[C++ Error] Cell2.hpp(198): E2347 Parameter mismatch in read access specifier of property PTGS

Code: Select all

class PASCALIMPLEMENTATION TFormulaCell : public TCell 
{
	typedef TCell inherited;
	
private:
	Sysutils::TByteArray *FPTGS;
	int FDataSize;
	int FFmlaSize;
	bool FCalculated;
	
public:
	__fastcall TFormulaCell(int RC, Cellformats2::TCellFormats* Formats, Word FormatIndex, Sysutils::PByteArray Val, int DataSize, int FmlaSize);
	__fastcall virtual ~TFormulaCell(void);



->>NEXT LINE HAS ERROR ->>->>NEXT LINE HAS ERROR ->>->>NEXT LINE HAS ERROR ->>->>NEXT LINE HAS ERROR ->>
	__property Sysutils::PByteArray PTGS = {read=FPTGS};


	__property int DataSize = {read=FDataSize, nodefault};
	__property int FormulaSize = {read=FFmlaSize, nodefault};
	__property bool Calculated = {read=FCalculated, write=FCalculated, nodefault};
};

second error here:

Code: Select all

[C++ Error] Cell2.hpp(312): E2347 Parameter mismatch in read access specifier of property ArrayData

Code: Select all

class PASCALIMPLEMENTATION TBaseArrayFormulaCell : public TFormulaCell 
{
	typedef TFormulaCell inherited;
	
protected:
	Sysutils::TByteArray *FArray;
	int FArraySize;
	bool FIsChild;
	
public:
	__fastcall TBaseArrayFormulaCell(int RC, Cellformats2::TCellFormats* Formats, Word FormatIndex, Sysutils::PByteArray Val, int DataSize, int FmlaSize, Sysutils::PByteArray Arr, int ArrSize, bool Child);
	__fastcall virtual ~TBaseArrayFormulaCell(void);


->> NEXT LINE HAS ERROR ->>->> NEXT LINE HAS ERROR ->>
	Sysutils::PByteArray __fastcall ArrayPTGS(void);


	int __fastcall ArrayPTGSSize(void);
	__property Sysutils::PByteArray ArrayData = {read=FArray};
	__property int ArraySize = {read=FArraySize, nodefault};
	__property bool IsChild = {read=FIsChild, nodefault};
};

next error:

Code: Select all

[C++ Error] Recordstoragechart2.hpp(79): E2347 Parameter mismatch in read access specifier of property Data

Code: Select all

class PASCALIMPLEMENTATION TChartRecord : public Contnrs::TObjectList 
{
	typedef Contnrs::TObjectList inherited;
	
public:
	TChartRecord* operator[](int Index) { return Items[Index]; }
	
private:
	Word FRecId;
	Word FLength;
	Sysutils::TByteArray *FData;
	TChartRecord* FParent;
	TChartRecord* __fastcall GetItems(int Index);
	void __fastcall ReadDefault(TDefaultRecord * DefRecs, const int DefRecs_Size, int &Index, Xlsfonts2::TXFonts* Fonts);
	Xlsfonts2::TXFont* __fastcall FindFBIFont(int Id);
	
public:
	__fastcall TChartRecord(TChartRecord* Parent, Biffrecsii2::TBIFFHeader Header, Sysutils::PByteArray D)/* overload */;
	__fastcall TChartRecord(TChartRecord* Parent, Word RecId, Word Length)/* overload */;
	__fastcall TChartRecord(TChartRecord* Parent, Word RecId, System::TObject* Obj)/* overload */;
	__fastcall virtual ~TChartRecord(void);
	void __fastcall Write(Xlsstream2::TXLSStream* Stream);
	void __fastcall Resize(int Delta);
	void __fastcall Read(Xlsstream2::TXLSStream* Stream, Sysutils::PByteArray PBuf, Xlsfonts2::TXFonts* Fonts);
	void __fastcall ReadDefaultRecords(TDefaultRecordData RecData);
	TChartRecord* __fastcall LastRec(void);
	TChartRecord* __fastcall InsertRecord(int Index, Word RecId, Word Length, bool IsUpdate = false);
	int __fastcall FindRecord(int Id);
	bool __fastcall FindRecordChilds(int Id);
	bool __fastcall RemoveRecord(int Id);
	TChartRecord* __fastcall Root(void);
	__property TChartRecord* Items[int Index] = {read=GetItems/*, default*/};
	__property TChartRecord* Parent = {read=FParent};
	__property Word RecId = {read=FRecId, nodefault};
	__property Word Length = {read=FLength, nodefault};


->> NEXT LINE HAS ERROR ->>->> NEXT LINE HAS ERROR ->>->> NEXT LINE HAS ERROR ->>
	__property Sysutils::PByteArray Data = {read=FData};


};

and next 2 errors in this strings:

Code: Select all

while(  XLS->FindText( edText->Text ) ) {

Code: Select all

while(  XLS->Sheet[ Sheet ]->FindText( edText->Text ) ) {

I newbie in programming... but i think that this problem must be not hard for c++ programmer... as i understand from Cell2.hpp header:

Code: Select all

// Borland C++ Builder
// Copyright (c) 1995, 2005 by Borland Software Corporation
// All rights reserved

// (DO NOT EDIT: machine generated header) 'Cell2.pas' rev: 10.00

you are Delphi programmer... ehh so i think that this error maybe hard to find for you...

...and yes... I dont have any versions of XLSReadWriteII installed before...

please try to help me...

[anuragsadana]

HI, I WAS FACING THE SAME PROBLEMS WHILE RUNNING THE SAMPLE PROGRAMS OF XLSREADWRITEII30.

I got solution to just run the sample programs anyhow.
Just remove the lines 198 and 312 in cell2.hpp and also line 79 in Recordstoragechart2.hpp (FOR WHICH THE ERRORS ARE COMING) and copy the files of the C:\Program Files\XLSReadWriteII30\Package\BDS2006 to these 3 locations:



C:\Program Files\Borland\BDS\4.0\include\vcl\

C:\Program Files\Borland\BDS\4.0\include\Indy9\

C:\Program Files\Borland\BDS\4.0\include\Indy10\


Also while running the program if "Unable to find" appears for the static library (for example XLSRWII20_CPP6.lib) and bpi files etc. then on this same message window, click on "Remove this reference".