Question
PricewaterhouseCoopers LLP - USA
US
Last activity: 17 Aug 2017 1:59 EDT
OLEDBQuery Output to Excel
Hi Im trying to write an OLEDBQuery result to an excel sheet, can someone please help me identify where I'm going wrong? Im able to get the query output but unable to write it to excel.
***Edited by Moderator Marissa to update categories***
Accepted Solution
Pegasystems Inc.
US
The result from GetTable is a DataTable. The Excel connector has a method called ImportData that takes a DataTable as a parameter. You would use this method as opposed to the SetCellValue method (unless you wanted to iterate through the DataTable and only add specific parts of it).
Accepted Solution
Pegasystems Inc.
US
The result from GetTable is a DataTable. The Excel connector has a method called ImportData that takes a DataTable as a parameter. You would use this method as opposed to the SetCellValue method (unless you wanted to iterate through the DataTable and only add specific parts of it).