Dumpt the result set from a data provider into excel

[system]

Hi All,

I am trying to dump the result set of a BO data provider into an existing excel file.

I understand I can loop through and dump the values with code like

ThisDocument.DataProviders(“MyDp”).Columns.Item(1).Item (1)…

However, is there an easier way to do it?

Currently I save the BO query as a txt file, then start excel and open the text file. It would be great if I could skip the intermediate step of saving the BO data to a text file and then having to load it back into an excel object.

Any help would be greatly appreciated.

Thanks!
Eric

---

ebowden00 (BOB member since 2005-05-25)

[system]

look just behind…

120×120 10.4 KB

Hi, I am using this code for excel export. I am getting error when i copying the sheet from one work book to final workbook. " source_workbook.Worksheets.Move Before:=final_workbook.Worksheets(“Sheet1”) " Can anyone help on this…? Thanks in advance. Sub expToExcel() 'Things to Add 'Add a sheet in the final Excel file depending upon the number of books in the report 'as by defalut there ‘****************************************************************************’ Dim doc As Document …

---

laguiff (BOB member since 2005-05-13)

[system]

@ebowden00

However, is there an easier way to do it?

Currently I save the BO query as a txt file, then start excel and open the text file. It would be great if I could skip the intermediate step of saving the BO data to a text file and then having to load it back into an excel object.

Any help would be greatly appreciated.

Have a look at this post for some other alternatives.

---

Dwayne Hoffpauir (BOB member since 2002-09-19)