4 Replies - 7505 Views - Last Post: 03 April 2008 - 12:31 PM Rate Topic: -----

#1 djessellis  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 13
  • Joined: 18-January 08

Exporting Data into an Excel Template

Posted 05 February 2008 - 03:07 AM

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.
Is This A Good Question/Topic? 0
  • +

Replies To: Exporting Data into an Excel Template

#2 Nayana  Icon User is offline

  • DIC Hawk - 나야나 नयन:
  • member icon

Reputation: 31
  • View blog
  • Posts: 824
  • Joined: 14-November 07

Re: Exporting Data into an Excel Template

Posted 05 February 2008 - 04:11 AM

Google is your friend.
Was This Post Helpful? 0
  • +
  • -

#3 largeformatnc  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 24-March 08

Re: Exporting Data into an Excel Template

Posted 24 March 2008 - 07:50 AM

View PostNayana, 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?
Was This Post Helpful? 0
  • +
  • -

#4 coh1ba  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 01-April 08

Re: Exporting Data into an Excel Template

Posted 01 April 2008 - 05:55 PM

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")



Was This Post Helpful? 0
  • +
  • -

#5 Fresh-o-matic  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 03-April 08

Re: Exporting Data into an Excel Template

Posted 03 April 2008 - 12:31 PM

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
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1