Transffering Data to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi
Can somebody help me with this issue
I'm exporting my data from Analysis Service to excel files using ADOMD.
I got hundreds of excel files that need to be inserted with cube data retrieved from ADOMD connection.
Each of the files would have a pre-defined location where i should start inserting data, for example "R3C4"(each file would be in different cell)
I need to open the existing file, adds data to it, save changes, and closes
I've tried so many ways to deal with problem, but still didn't work. Can anyone show me how to do this?
Thank
 
Thanks Cor for you immediate respond.

I've read the article before.
Most of the sample supposing you're creating a new instance of Excel, then manipulate the data using Insert, Delete, Update command. I can't figure it out to to use them to solve my problem. I need to specify from which cell i should start inserting the data, and then begin insert data from that point.
The sequence would probably as simple as this: open excel file, go to the cell where i should start inserting the data, start insert the data to columns and rows, save excel file, close excel file, open another file and repeat the same thing
This probably not the best way, but it is an option.

n.b.: i'm quite new with excel.

Yanto

----- Cor Ligthert wrote: -----

Hi Yanto,

The only help I can give you in this is some links

Office
http://support.microsoft.com/default.aspx?scid=kb;EN-US;311452

http://msdn.microsoft.com/office/

Pia Download
http://www.microsoft.com/downloads/...1e-3060-4f71-a6b4-01feba508e52&displaylang=en

Excel dataset fill and updat
http://support.microsoft.com/default.aspx?scid=kb;EN-US;316934

Anyway I hope this helps as well a little bit?

Cor
 
Hi Yanto,

When I was you I would ask this too in a special Excel newgroup, not that I
know, however when you can do it with Excel development the step to VB.net
is much easier I think.

I did a long time nothing with this.

Cor
 
¤ hi,
¤ Can somebody help me with this issue.
¤ I'm exporting my data from Analysis Service to excel files using ADOMD.
¤ I got hundreds of excel files that need to be inserted with cube data retrieved from ADOMD connection.
¤ Each of the files would have a pre-defined location where i should start inserting data, for example "R3C4"(each file would be in different cell).
¤ I need to open the existing file, adds data to it, save changes, and closes.
¤ I've tried so many ways to deal with problem, but still didn't work. Can anyone show me how to do this?
¤ Thanks

You may want to look at some of the MS KB examples that use automation:

HOWTO: Automate Excel from Visual Basic .NET to Fill or to Obtain Data in a Range by Using Arrays
http://support.microsoft.com/default.aspx?scid=kb;en-us;302094&Product=vbNET

HOWTO: Automate Microsoft Excel from Visual Basic .NET
http://support.microsoft.com/default.aspx?scid=kb;en-us;301982&Product=vbNET


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Thanks Paul
The sample shows some way to deal with my problem. Again, thanks

Yanto

----- Paul Clement wrote: ----


¤ hi
¤ Can somebody help me with this issue
¤ I'm exporting my data from Analysis Service to excel files using ADOMD.
¤ I got hundreds of excel files that need to be inserted with cube data retrieved from ADOMD connection.
¤ Each of the files would have a pre-defined location where i should start inserting data, for example "R3C4"(each file would be in different cell)
¤ I need to open the existing file, adds data to it, save changes, and closes
¤ I've tried so many ways to deal with problem, but still didn't work. Can anyone show me how to do this?
¤ Thank

You may want to look at some of the MS KB examples that use automation

HOWTO: Automate Excel from Visual Basic .NET to Fill or to Obtain Data in a Range by Using Array
http://support.microsoft.com/default.aspx?scid=kb;en-us;302094&Product=vbNE

HOWTO: Automate Microsoft Excel from Visual Basic .NE
http://support.microsoft.com/default.aspx?scid=kb;en-us;301982&Product=vbNE


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic
 
Hi Cor

Thanks for your advice

Yant

----- Cor Ligthert wrote: ----

Hi Yanto

When I was you I would ask this too in a special Excel newgroup, not that
know, however when you can do it with Excel development the step to VB.ne
is much easier I think

I did a long time nothing with this

Co
 
Back
Top