Axolot Data

Hi Lars,

i have a XLSM file with charts and macros.

When i do this
the file corrupted.

Can you help me

... and

ACell.AsString on a float cell get a false result

Hello

thanks to fix the event, but the function ColRowToRefStr(ACell.Col,ACell.Row) get following for xvExcel97:

A Excel table with 2 columns:

A1, B1, C1, D1, E1, F1,... ???

I think: A1, B1, A2, B2, A3, B3,... is right

under xvExcel2007 its right

When read Excel97 file the OnReadCell Event not fired.
Excel2007 files works fine.
Have testet with ReadDirect Sample with Version xvExcel97.

Delphi2007
Windows XP SP3
ExcelReadWriteII V5 .10.21

Thanks

Hello,
just wanted to ask again as the state of "Import Sheets from external Excelfile" is.

no response???

Hello,

oh no! Is there no way over a stream (XLSStream) or step by step.
... or can i hope in the next version gives a copysheet function?

... no response?

... but I do not want to use OLE I bought XLSReadWriteII

Please help me

Uwe Braune

Hello, Fine, this works. But i need all data on the sheet - Formats, Charts, Printing Range an so on ... Over OLE i do this: [code] function XLSReport_multi(Reports: TStrings; aToFile: string): boolean; var Excel : OleVariant; CopyBook : OleVariant; CopySheet : OleVariant; WorkBook : OleVariant; Wor...

Hello, you wrote me 2006: [quote] ... This will be added to a future upgrade ... and ... The feature to copy sheets between components is on the to do list, but I can't tell when it will be ready. [/quote] ... and now 2012 you wrote: [quote] There is no method for copying sheets from external files....

Hello, all the Excelfiles creates with XLSReadWriteII4 and i can read this files but i can't copy the Sheets from extern file. Please help me... function XLSReport_multi(Reports: TStrings): boolean; var i : integer; XLSFrom : TXLSReadWriteII4; XLSTo : TXLSReadWriteII4; begin Result := false; try XLS...