Search found 3 matches
- Tue Apr 02, 2013 9:33 am
- Forum: XLSReadWriteII 3/4/5
- Topic: Problem with ExportCSV and two or more SelectedAreas
- Replies: 0
- Views: 7932
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...
- Tue Sep 06, 2011 9:31 am
- Forum: XLSReadWriteII 3/4/5
- Topic: Format numeric columns imported with TXLSDBRead4
- Replies: 2
- Views: 3720
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...
- Thu Sep 01, 2011 9:29 am
- Forum: XLSReadWriteII 3/4/5
- Topic: Format numeric columns imported with TXLSDBRead4
- Replies: 2
- Views: 3720
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
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