write the resultSet into Excel sheet

Hi All,

I can write the resultset data into Excel sheel… cell by cell. When there is more records in Result set it is taking too much time. Instead can we paste the data as it is in Resultset?

Is that possible. Or can we reduce the writing time anyway?

Pls advise me.

Thanks,

Maria.

Hi Maria,

Write the resultset in csv file and open the csv file in excel,it will faster.

for example try like this

static void ResultInExcel(Args _args)
{
CommaIO commaIO;
Str fileName;
CustTable custTable;
;

fileName = WinAPI::getTempPath() + “CustomerDate” + “.csv”;
commaIO = new CommaIO(fileName,“w”);

while select custTable
{
commaIO.write(custTable.AccountNum,custTable.Name);
}

WinAPI::shellExecute(fileName);
}

Naresh Kolli