XEROF

 

xlsgen 4.0.0.30 : Additional CSV import option


Build 4.0.0.30 of xlsgen adds another option when importing CSV files, which is to override the automatic data type discovery in favor of a predefined data type.

In the sample below, the CSV content is imported as strings.

engine->Workbooks->CSVImportOptions->ForceDataType = xlsgen::datatype_string;

xlsgen::IXlsWorkbookPtr wbk = engine->Open( L"input.csv", L"output.xlsx" );

xlsgen::IXlsWorksheetPtr wksht = wbk->WorksheetByIndex[1];

WCHAR sDimensions[128];
swprintf(sDimensions, L"R%dC%d:R%dC%d",
    wksht->Dimensions->FirstRow,
    wksht->Dimensions->FirstColumn,
    wksht->Dimensions->LastRow,
    wksht->Dimensions->LastColumn);
wksht->Columns[sDimensions]->AutoFit = TRUE;

wbk->Close();

Posted on 11-April-2016 22:52 | Category: xlsgen, Excel generator | comment[0] | trackback[0]

 

 

<-- previous page

< April >
0102030405
0607080910
1112131415
1617181920
2122232425
2627282930



 

 

This site
Home
Articles

DevTools
CPU-Z
EditPlus
ExplorerXP
Kill.exe
OllyDbg
DependencyWalker
Process Explorer
autoruns.exe
Araxis
COM Trace injection
CodeStats
NetBrute
FileMon/Regmon
BoundsChecker
AQTime profiler
Source monitor
GDI leaks tracking
Rootkit revealer
Rootkit removal
RunAsLimitedUser(1)
RunAsLimitedUser(2)

 

 

Liens
Le Plan B
Un jour à Paris
Meneame
Rezo.net (aggr)
Reseau voltaire
Cuba solidarity project
Le grand soir
L'autre journal
Le courrier suisse
L'Orient, le jour
Agoravox (aggr)