473,406 Members | 2,312 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

translate xls to xml

Hi

I have excel file and I used xml database.The problem is that I would
transfered all data of excel files in my db.
It's possible but I don't know how.

Thanks
Nov 20 '05 #1
6 5448
Please post this in the excel newsgroup.

Benny

Bruno wrote:
Hi

I have excel file and I used xml database.The problem is that I would
transfered all data of excel files in my db.
It's possible but I don't know how.

Thanks


Nov 20 '05 #2
But it's in vb.net program who the entry file is xls file and this program
work with a database xml( type dataset).
"Benny Mathew" <be***@mvps.org> a écrit dans le message de
news:O0**************@TK2MSFTNGP12.phx.gbl...
Please post this in the excel newsgroup.

Benny

Bruno wrote:
Hi

I have excel file and I used xml database.The problem is that I would
transfered all data of excel files in my db.
It's possible but I don't know how.

Thanks

Nov 20 '05 #3
Nevermind him <G>

I've accomplished what you need by adding a reference to the Excel COM
objects. Then use the COM objects to pull data from the various cells. From
there it's just a matter of deciding where in your xml database to put the
data.
"Bruno" <bo*************@wanadoo.fr> wrote in message
news:e3**************@TK2MSFTNGP11.phx.gbl...
But it's in vb.net program who the entry file is xls file and this program
work with a database xml( type dataset).
"Benny Mathew" <be***@mvps.org> a écrit dans le message de
news:O0**************@TK2MSFTNGP12.phx.gbl...
Please post this in the excel newsgroup.

Benny

Bruno wrote:
Hi

I have excel file and I used xml database.The problem is that I would
transfered all data of excel files in my db.
It's possible but I don't know how.

Thanks


Nov 20 '05 #4
Even better idea... I bet you can use the OleDbDataAdapter to open the
spreadsheet and fill a dataset. From there, it's a piece of cake to save it
to your XML file.
"Jeff Molby" <JeffMolby@C_mc_st.n_t> wrote in message
news:eq**************@TK2MSFTNGP11.phx.gbl...
Nevermind him <G>

I've accomplished what you need by adding a reference to the Excel COM
objects. Then use the COM objects to pull data from the various cells. From there it's just a matter of deciding where in your xml database to put the
data.
"Bruno" <bo*************@wanadoo.fr> wrote in message
news:e3**************@TK2MSFTNGP11.phx.gbl...
But it's in vb.net program who the entry file is xls file and this program work with a database xml( type dataset).
"Benny Mathew" <be***@mvps.org> a écrit dans le message de
news:O0**************@TK2MSFTNGP12.phx.gbl...
Please post this in the excel newsgroup.

Benny

Bruno wrote:

> Hi
>
> I have excel file and I used xml database.The problem is that I would > transfered all data of excel files in my db.
> It's possible but I don't know how.
>
> Thanks
>
>



Nov 20 '05 #5
Top Answer.

Sometimes ( but not often ) even I get carried away with redirecting
questions.

Regards OHM
"Jeff Molby" <JeffMolby@C_mc_st.n_t> wrote in message
news:%2***************@TK2MSFTNGP12.phx.gbl...
Even better idea... I bet you can use the OleDbDataAdapter to open the
spreadsheet and fill a dataset. From there, it's a piece of cake to save it to your XML file.
"Jeff Molby" <JeffMolby@C_mc_st.n_t> wrote in message
news:eq**************@TK2MSFTNGP11.phx.gbl...
Nevermind him <G>

I've accomplished what you need by adding a reference to the Excel COM
objects. Then use the COM objects to pull data from the various cells.

From
there it's just a matter of deciding where in your xml database to put the
data.
"Bruno" <bo*************@wanadoo.fr> wrote in message
news:e3**************@TK2MSFTNGP11.phx.gbl...
But it's in vb.net program who the entry file is xls file and this

program work with a database xml( type dataset).
"Benny Mathew" <be***@mvps.org> a écrit dans le message de
news:O0**************@TK2MSFTNGP12.phx.gbl...
> Please post this in the excel newsgroup.
>
> Benny
>
> Bruno wrote:
>
> > Hi
> >
> > I have excel file and I used xml database.The problem is that I would > > transfered all data of excel files in my db.
> > It's possible but I don't know how.
> >
> > Thanks
> >
> >
>



Nov 20 '05 #6
Thanks lot,
i try it now

"Jeff Molby" <JeffMolby@C_mc_st.n_t> a écrit dans le message de
news:%2***************@TK2MSFTNGP12.phx.gbl...
Even better idea... I bet you can use the OleDbDataAdapter to open the
spreadsheet and fill a dataset. From there, it's a piece of cake to save it to your XML file.
"Jeff Molby" <JeffMolby@C_mc_st.n_t> wrote in message
news:eq**************@TK2MSFTNGP11.phx.gbl...
Nevermind him <G>

I've accomplished what you need by adding a reference to the Excel COM
objects. Then use the COM objects to pull data from the various cells.

From
there it's just a matter of deciding where in your xml database to put the
data.
"Bruno" <bo*************@wanadoo.fr> wrote in message
news:e3**************@TK2MSFTNGP11.phx.gbl...
But it's in vb.net program who the entry file is xls file and this

program work with a database xml( type dataset).
"Benny Mathew" <be***@mvps.org> a écrit dans le message de
news:O0**************@TK2MSFTNGP12.phx.gbl...
> Please post this in the excel newsgroup.
>
> Benny
>
> Bruno wrote:
>
> > Hi
> >
> > I have excel file and I used xml database.The problem is that I would > > transfered all data of excel files in my db.
> > It's possible but I don't know how.
> >
> > Thanks
> >
> >
>



Nov 20 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Bengt Richter | last post by:
Just thought None as the first argument would be both handy and mnemonic, signifying no translation, but allowing easy expression of deleting characters, e.g., s = s.translate(None,...
1
by: shank | last post by:
I'm sure this is a stretch, but is there some kind of component that I could install to translate from English to Spanish on the fly? I have a lot of equipment features and specifications that I...
4
by: Gadrin77 | last post by:
I have data that looks like <Root> <Main Value="Line1|Line2.|Line3|Line4.|Line5"/> </Root> I'm using Translate(@Value, "|.", ",")
6
by: bobueland | last post by:
The module string has a function called translate. I tried to find the source code for that function. In: C:\Python24\Lib there is one file called string.py I open it and it says
6
by: Anders K. Olsen | last post by:
Hello group I'm trying to list the users and groups who has read access to a file. I use .NET 2.0 and FileInfo.GetAccessControl().GetAccessRules(...) and then loop through the...
1
by: peterbe | last post by:
This has always worked fine for me. Peter fine Now if I do it with a unicode string: Traceback (most recent call last): File "<stdin>", line 1, in ? File "/usr/lib/python2.4/string.py", line...
9
bvdet
by: bvdet | last post by:
I have done some more work on a simple class I wrote to calculate a global coordinate in 3D given a local coordinate: ## Basis3D.py Version 1.02 (module macrolib.Basis3D) ## Copyright (c) 2006...
1
by: =?Utf-8?B?R2F1cmF2?= | last post by:
Hi, I am using the Translate() function in one of the .XSLT file to remove the spaces, like this: <xsl:for-each select=".//Illustration"> <xsl:value-of select="translate(./@illusName, ' ',...
3
by: Kenneth McDonald | last post by:
I have the need to occasionally translate a single word programatically. Would anyone have a Python script that would let me do this using Google (or another) translation service? Thanks, Ken
4
by: kovariadam | last post by:
Hi, Does anybody know why i get this error: SQL0176N The second, third or fourth argument of the TRANSLATE scalar function is incorrect. SQLSTATE=42815 with this query: SELECT...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
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,...
0
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...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
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,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.