Search found 3 matches

by Bigun
Tue Apr 02, 2013 9:33 am
Forum: XLSReadWriteII 3/4/5
Topic: Problem with ExportCSV and two or more SelectedAreas
Replies: 0
Views: 7652

Problem with ExportCSV and two or more SelectedAreas

I'm trying to export to CSV different columns (areas) of a XLS file using XLSReadWriteII v4 and C++ XE2. What I do basically is: XLSReadWriteII41->Read(); TSheet *Pag0= XLSReadWriteII41->Sheets->Items[0]; // Select desired areas Pag0->SelectedAreas->Add(2,0,2,999); // C1-C999 Pag0->SelectedAreas->Ad...
by Bigun
Tue Sep 06, 2011 9:31 am
Forum: XLSReadWriteII 3/4/5
Topic: Format numeric columns imported with TXLSDBRead4
Replies: 2
Views: 3701

Re: Format numeric columns imported with TXLSDBRead4

Thanks for answering. Yes, I use the TXLSDbRead4 component which imports data from a kbmMemTable. One of the fields/columns is defined as ftBCD. I've checked the code of TXLSDbRead4 and I've seen that values from ftBCD columns are writen Cell->AsFloat. Thats why I'm surprised when the resulting Exce...
by Bigun
Thu Sep 01, 2011 9:29 am
Forum: XLSReadWriteII 3/4/5
Topic: Format numeric columns imported with TXLSDBRead4
Replies: 2
Views: 3701

Format numeric columns imported with TXLSDBRead4

Hi,

I've just changed my old Excel component to XLSReadWriteII4.
Applying the new component in a data exporting function I see that the resulting Excel file does not format the columns of Float fields in the table.
For example, 2.000,10 appears as 2000,1.

¿How can I do this?
Thanks in advance