Axolot Data

Yes, the C++ code did exactly what I needed it to do.

Here's my work-around (with all error handling and other non-essential lines removed). Development was in C++Builder, but hopefully people can convert to Delphi, if required. TXLSReadWriteII4* xls = new TXLSReadWriteII4(NULL); xls->Filename = fn; xls->Version = xvExcel97; if(!xls->Sheets->Count) xls...

I understand. In my case they are logo files, which are stored in one place only - so having multiple copies of the files doesn't work in this case.

Changing the PictureName didn't work for me (it gave an error that the name was invalid). However, I managed to work around the problem by using LoadFromFile for the TMSOPicture and then setting PictureId of the TDrwPicture, instead of setting the PictureName. To value of PictureId needs to be the s...

Just to clarify, when I refer to the values 12.75 and 15, those are the row heights as shown in Excel - in my code I set the DefaultRowHeight to 300 (ie. 15*20), but Excel still shows the height as 12.75 for the rows which I don't specifically set the height for. I just tried again now with a value ...

Hi, I use XLSReadWriteII v4 to create a workbook, then I create a spreadsheet and I set the DefaultRowHeight for the sheet to 15. However, when I open the workbook in Excel, the default row height is 12.75. I have tried different values for DefaultRowHeight, as well as verifying the value before the...

Further investigation has revealed that FontColor should be specified as RGB, rather than one of the Excel colours. I then tried "cl->FontColor = XColorToRGB(xcGray50)", but that gave me R=128, G=128, B=0! For now I have worked around this by assigning "cl->FontColor = 0x7f7f7f",...

I have used the following (C++) code to assign a value to a cell and format it: xlSht->AsString[0][0] = "Report for " + dtMthStart.FormatString("mmmm yyyy"); TCell* cl = xlSht->Cell[0][0]; cl->FontName = "Arial Black"; cl->FontStyle = TXFontStyles() << xfsBold; cl->Font...