Axolot Data

I would like to suggest to all major component vendors and those who make products with Delphi to purchase "Delphi" from Idera and do not, repeat do not make it open source but keep it commercially supported (capitalism). The component vendors and product developers love Delphi and we need...

In the next update, can you add 64bit Signed and Unsigned Integers to TSheet cell values?

I am importing a BIGINT datatype from a database and getting an overflow error using AsInteger.

Log story short, are the following functions thread safe? Sheet.CellType[ColNo, Row] Sheet.AsString[ColNo, Row] Sheet.AsVariant[ColNo, Row] Long Story: I am reading data from an excel file and importing that into a database. I want to use the XE7 threading library and FireDAC Array DML to quickly re...

FYI - If anyone else has this problem the workaround for it is to add VCL and VCL.Imaging to the Unit Scope Names of your project options.

XLSReadWriteII5 does not compile in Console, Service, or ISAPI applications due to the compiler not finding the Graphics unit. This works ok in a VCL application but appears that in console apps you must preceded the unit name with "VCL.". Please fix soon because my excel code is in a VCL,...

I have upgraded to v5 and now all my date cells are just numbers when I open it in excel. My program mainly exports data from a query to excel, so a whole column except for the header should be a date format. Below is test code showing the date problem, but I want to know what the most effcient way ...

I am having trouble upgrading from v4 to v5. I am running this in XE. The following code does not set the font to Arial, instead is set to Calibri, The date and float columns does not set the font size to 8 and instead is set to 11. The color of the header is not xcPaleSky but is an orange color. pr...

I have upgraded from version 4 to the current version 5 and the following code snip no longer compiles, what is the correct way to do this in version 5? I get error [DCC Error] XLSRWHelp.pas(62): E2010 Incompatible types: 'Cardinal' and 'TXc12IndexColor' // Set background color for Column Headers (w...

I have a file that if I open the file, write to a cell, then save the file - then open the file in Excel and as soon as I try to type in the cell Excel tells me that it is protected. Also, the coloring gets messed up on one of the columns. I cannot upload the file, please email me for the file at be...

That post was in 2008 and you may have an updated version.

I tested and found that the below test code creates the Canvas does not allow drawing error. Adding a ReleaseDC call fixes it. [code] procedure TForm10.Button1Click(Sender: TObject); procedure DoIt; var Canvas: TCanvas; F: TFont; begin Canvas := TCanvas.Create; Canvas.Handle := GetDC(0); try F := TF...

I am getting "Canvas does not allow drawing" on the following line: Line: [code] Result := Round((FWidth / 256) * Canvas.TextWidth('8')); [/code] Source: [code] function TXLSColumn.GetPixelWidth: integer; var Canvas: TCanvas; F: TFont; begin Canvas := TCanvas.Create; Canvas.Handle := GetDC...

Hello, I have an excel file (97-2003) with a cell that has a background color of E3B48D. When I read the Cell.CellColorRGB property I get FFCC99. These colors are each variants of blue but some other colors have a more drastic difference for example Excel has 538ED5 (a blue) and Cell.CellColorRGB re...

If the file version is 2007, Sheet.PrintSettings.Footer returns an empty string. Its ok in the 97-2003 version.

In a 2007 version, the margins do not seem to be getting the correct values. My excel file has a Top margin of 0.75in and a left Margin of 0.25in. However, Sheet.PrintSettings.MarginLeft returns 0.75 and Sheet.PrintSettings.MarginTop returns 1.0

This seems to be ok if the file was a 97-2003