[djessellis]

Hi guys -

I am not looking for specific code here, but maybe one of you will know of a resource I can use to guide me.

I am looking to export data from Business Objects (neumeric data held in tables) into a pre-defined Excel Template. If you know of any websites/tutorials, etc, that deal with these sorts of processes please send me a link.

Much appreciated.

[Nayana]

Google is your friend.

[largeformatnc]

Nayana, on 5 Feb, 2008 - 04:11 AM, said:

Google is your friend.

"Google is your friend"

What a brilliant solution! How do you suppose most of us found the question in the first place?

[coh1ba]

To actually answer your question easiest thing to remember is that when dealing with excel you need to know the spreadsheet name, and cell location where you want the data. If your unsure you can also parse the excell sheet looking for where you want to place the data.

Another tip is that cells in excel are on a x,y grid. So a1 is actualy referenced as cell 1,1

Another tip don't forget to add in the Microsoft Excel Library in your projects references, again this might be VB 101 for you and your like DUH give me something I can use. So since you didn't specify if the template existed or didn't i'll give the ripped straight from Microsoft MSDN answer on creating a excel spreadsheet.

Dim ExcelSheet As Object
Set ExcelSheet = CreateObject("Excel.Sheet")


' Make Excel visible through the Application object.
ExcelSheet.Application.Visible = True
' Place some text in the first cell of the sheet.
ExcelSheet.Application.Cells(1, 1).Value = "This is Putting Data in column A, row 1"
' Save the sheet to C:\test.xls directory.
ExcelSheet.SaveAs "C:\TEST.XLS"
' Close Excel with the Quit method on the Application object.
ExcelSheet.Application.Quit
' Release the object variable.
Set ExcelSheet = Nothing


'There are many other options you can do like rename sheets select a sheet by name some versions of VB 
'allow you to also give the cell location as excelsheet.application.cells("A",1)  or say 
' excelsheet.application.cells("R","4")

[Fresh-o-matic]

You can create the excel file on Bob/bobxi (Business Objects).

Just do the usual:

1) Create your report, adding appropriate fields etc
2) Run the report
3) Modify the layout of the report using bob's Java Panl
4) Save Disk -> Save to computer as Excel

Just do what ever you like, save the report in you business objects inbox then you can re-run/modify it and save as an excel spreadsheet whenever you want.

Not sure if that was what you are after...

Regards
FreshMatic