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 6 1613
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...b;EN-US;311452 http://msdn.microsoft.com/office/
Pia Download http://www.microsoft.com/downloads/d...displaylang=en
Excel dataset fill and updat http://support.microsoft.com/default...b;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
On Sun, 25 Apr 2004 23:06:03 -0700, "Yanto" <an*******@disc ussions.microso ft.com> 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?
¤ 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...&Product=vbNET
HOWTO: Automate Microsoft Excel from Visual Basic .NET http://support.microsoft.com/default...&Product=vbNET
Paul ~~~ pc******@amerit ech.net
Microsoft MVP (Visual Basic)
Thanks Paul
The sample shows some way to deal with my problem. Again, thanks
Yanto
----- Paul Clement wrote: ----
On Sun, 25 Apr 2004 23:06:03 -0700, "Yanto" <an*******@disc ussions.microso ft.com> 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...4&Product=vbNE
HOWTO: Automate Microsoft Excel from Visual Basic .NE http://support.microsoft.com/default...2&Product=vbNE
Paul ~~~ pc******@amerit ech.ne
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Chris |
last post by:
Could someone please provide me an effective means of
exporting data from a data set (or data grid) to Excel?
|
by: Niyazi |
last post by:
Hi,
I have to retrieve a data from AS400 DB2 and after working with data I have
to export into one of existing Excel file.
I can connect into specific library in AS400 DB2 using AS400 Client-Access
v5.2 program using (in VB.NET) ODBC driver (DSN Name …) . I can retrieve
datam work on it using VB.NET and I can send into 'NEW' Excel file.
My first problem starts here:
|
by: Steven Stewart |
last post by:
I have a user who has been using Excel for a while to keep statistics
and print reports. She finds using it cumbersome because of long
formulas and a lot of copying and pasting.
I have designed a database for her which is intended to make things a
lot easier; however, I don't have a lot of experience with Access and
I find that designing the reports in Access is tedious. I want to be
able to print the reports (which are simply based on...
|
by: bhavsar vaishali |
last post by:
i have one form. form which i will send checkbox ary in other page to
delete that selected records but i want to firt confirm to user to delete that records and for that i want one dialog box( window). i have created one window but i get problem in passing data because i have called that dialog box ( window) in image buttons onclick event and the check box selected array cant be send to that window becuase data can be send in page which is...
|
by: Grip |
last post by:
Hi,
I have gone throught the group and Microsoft's online help and have
seen many suggestions but I am still seeking clarity:
1. I have an excel spreadsheet. Column A contains text that may be
greater than 255 characters.
2. I have an access database. I link (not import) to the contents of
the excel spreadsheet. In the design view in access, Column A has the
data type "memo".
| |
by: jwmaiden |
last post by:
Have an application that opens up a webbrowser control to display data in an Excel spreadsheet (using VB.NET in VS 2005). No problem with opening the spreadsheet or displaying the data, but I'm having problems with repeating the process. I want to create an Excel spreadsheet, add some data to it, and display the results in a webbrowser control. I want to be able to then later delete the old Excel spreadsheet, create a new one, add some new data,...
|
by: sejal17 |
last post by:
hello
Can any one tell me how to read multiple worksheets from a single excel file.I have stored that excel in xml file.so i want to read that xml that has multiple worksheet.And i want to store that multiple worksheet data in different table.How can i do it.Below is my xml file.
<?xml version="1.0"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
...
|
by: sejal17 |
last post by:
hello
Can any one tell me how to read multiple worksheets from a single excel file.I have stored that excel in xml file.so i want to read that xml that has multiple worksheet.And i want to store that multiple worksheet data in different table.How can i do it.Below is my xml file.
<?xml version="1.0"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"...
|
by: TG |
last post by:
hi!
I am trying to create a sql server table from an excel sheet.
Here is the code I have:
'This procedure the xlsx file and dumps it to a table in SQL Server
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |