Saving a xls file as a xml spreadsheet from c#

Hi folks!

My 1st post on this forum!

I'm trying to save an .XLS file as a .XML Spreadsheet (Excel 2003) from C# Express (.NET2). I've pretty much got the coding but am stuck on the following:

ExcelObj.ActiveWorkbook.SaveAs(fileout, xlNormal, false, false, false, false, Excel.XlSaveAsAccessMode.xlNoChange, false, false, 0, false, false);

The 2nd parameter should be a FileFormat object of XML Spreadsheet, but so far I've had no luck finding out how this is defined (I know that xlNormal = -4143 : this saves a xls file).

Any help would be really appreciated :)

Aug 7 '06 #1

Subscribe Post Reply

6060

GBNeil

Hi again folks!

Problem resolved - turns out the answer is 46 (not 42!). Just needed to look inside the Object Browser in VB within Excel.

If anyone is interested, I'll be glad to post the code.

Cheers!

Aug 7 '06 #2

kenobewan

4,871

Expert 4TB

Well done! Feel free to post in the articles section so that others may benefit. Thanks.

Aug 8 '07 #3

bklight

Neil

can u please post your code ...
I have to save and .xlsx file in xsml spreadsheet format and get XML data from it.
It would be glad if u post ur code asap

Jan 13 '10 #4

by: Paul | last post by:

I was wondering if anyone has had an issue where using vba code to read an excel file and import the data into an access table some records are not imported from the excel file. It seems looking at...

Microsoft Access / VBA

Saving and Downloading a single record

by: S. Graefner | last post by:

Hello Folks, I'm a Relitive newbie to the blood sport of MS ACCESS. I have designed and built a database with multiple, Related, tables. The db works well, more by good luck then good planing I...

Microsoft Access / VBA

Urgent Help on Australian dates on spreadsheet saving as American dates on a text file.

by: Dixie | last post by:

I have a spreadsheet that uses VBA code in Access to save itself as a text file. The line is as follows. xl.ActiveSheet.SaveAs CurrentProject.Path & "\Reports\" & DLookup("", "tblButtons",...

Microsoft Access / VBA

Saving Spreadsheet to Unicode extra quotation marks

by: Fendi Baba | last post by:

I tried converting a spreadsheet with a mix of Thai characters and English to a unicode text files. I had work on an assumption that the default delimiter was a tab (Chr(9)). However some columns...

Microsoft Access / VBA

Saving Excel spreadsheet to a specific location

by: maxamis4 | last post by:

Hello, I have created a spreadsheet which I want to save in the location where it resides. I user the following to save the sheet objApp.ActiveWorkbook.Save But i want to specify where...

Microsoft Access / VBA

open an excel file and paste values

by: toffee | last post by:

Hi all, I got a pre-formatted spreadsheet. would it be possible using js to copy the data from a table on the current webpage, open the spreadsheet and paste the content ? if so, anyone got any...

Javascript

Is there anyway to stream an automated file without saving to diskfirst?

by: Karl | last post by:

Hi all, It may seem like a rather odd request (or not) but I would like to be able to create a file (doc, jpg, xls or one of many other files that can be automated) on a website and stream it to...

.NET Framework

Saving images in Excel report

by: Eddie | last post by:

Hi all, I am displaying a number of reports, and giving the users an option to display them on the web or download them to Excel. If they want the Excel file, I just use the PHP header command...

PHP

Problem faced while creating Excel file !!!!

by: vijayarl | last post by:

Hi Everyone, Am trying to collate the individual xls files into a single xls file.i have written this code. use strict; use Spreadsheet::WriteExcel; use Spreadsheet::ParseExcel; use...

Perl

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

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...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

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,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

Saving a xls file as a xml spreadsheet from c#

Similar topics