Axolot Data

This code generates an exception because there is no cell at A1: XLS := TXLSReadWriteII5.Create(nil); XLS.Sheets[0].Cell[0, 0].FillPatternForeColorRGB := 0; Earlier that was solved by setting LastCol and LastRow to a value. Now, these are not writeable any more. What is now the preferred method of c...

[quote="vga"]I want to remove Protection of a xls file, [/quote] It seems that the current version erroneously inserts sheet protection into the xls file regardless of your code. I have already reported this as a bug. It has existed afaik at least since 4.00.49, but may be related to readi...

Hi! I have a PDF generator which allows me to paint to its TCanvas. Can XLSSpreadSheet be painted onto a TCanvas? Like XLSSpreadSheetInstance.PaintTo(PDFDocument.Canvas) ? I want to be able to generate PDF files from Excel sheets in the background, with no visible things for the user. For example: F...

I think the error is in the reading of my XLS fil itself because the AV was caused by the Column being nil. Using MS Excel 2002, I create a new XLS file, just adding the text a, b and c to columns A, B and C respectively. When reading the file, the Sheet.Columns[] array are all nil although, the Las...

Please consider this test code with XLSReadWriteII2 version 3.01.05: FXLS := TXLSReadWriteII2.Create(Self); FXLS.FileName := 'test.xls'; FXLS.Read; Memo1.Lines.Add(IntToStr(FXLS.Sheets[0].Columns[0].PixelWidth)); I generates an AccessViolation on this line in Columns2.pas: Line 242: FFormats.Fonts[0...