Axolot Data

Load and save of a XLSX which has picture inside the header the results in a broken file.

since the last version CR/LF in Cells of XLS-Files are destroyed while reading.
A Cell with the content results in Sheet.AsString[x,y] = "123"

Same error with names containing a "-" (minus) and "(" / ")" (parentheses) and "!"

I know that the default name is "Sheet1", but I set the name of the first sheet to "Sheet Name". Then I try to add an autofilter.

The following Code crashes with Exception 'E4016: Uknown sheet name "Name"'.

Hello The next major version will be 6.00.00 in 2012 I ask how to create charts in XLSX (with XLSRWII4) Your answer was: "This will be fixed in Version 5"! You can however use charts if you have a template XLSX file with the charts. I've to create a variable number of charts with differen...

When can I expect it? What do you call "major Update"? Version 5.30?

I have to create charts, too.

The sample sets XLS.Version to xvExcel97 and uses XLS.BIFF. I use XLSX-Format. The sample does not work, because XLS.BIFF is nil.

How do I create Charts with XLS.Version = xvExcel2007?

The procedure TXLSWorksheet.CalcDimensionsEx does not work correct. first Xc12Sheet.Dimension is assigned to Area, then area is set to max-Values. After that the method iterates over the cells and adjusts the area, when the cell is not inside of FXc12Sheet.Dimension (Area should be the right variabl...

I try to create borders around some cells with the following code: 0: FSheet.AsString[x,y] := ''; //"Create" cell 1: MakeBorder(FSheet.Cell[x,y]); procedure TqsmComarisonViewXLSExport.MakeBorder(const ACell: TXLSCell); begin 2: ACell.BorderLeftStyle := cbsThin; 3: ACell.BorderLeftColor := ...

I tryed to set the FillPatternForeColor with an user defined indexed color. But I always got the wrong colors. While debugging through the XLSRWII5-Code, I realized that IndexColorToXc12 uses the TXc12DefaultIndexColorPalette instead of the TXc12IndexColorPalette which contains my colors. I bypass t...

Hello, i've figured out, that the right setting is Sheet.PlotArea.CategoryAxis.CatSerAxisScaling.LabelsFrequency however I'm not able to set this Value in a new created file. If I open a created file in EXCEL (2013), the "best fitting" value is selected. If I save the File (without any cha...

I create a new Chart on a sheet with sheet.Charts.Add(sheet.Index); everything works well. But if I have many values excel only prints every second (or less) label. If tried to set the label frequency with: chart.PlotArea.SerieAxis.CatSerAxisScaling.LabelsFrequency := 1; but this results in an Error...

still not solved...

in XLSReadWriteII4 I add an autofilter with XLS.Sheet[0].Autofilters.Add(0, 4, 3, 4); in Version 5 the method "ADD" does not exist. How can I create an autofilter in XLSReadWriteII5? In my existing Code, I can Create fixed header rows with to following code: sheet.Pane.SplitColX := 0; shee...