Saving Excel file as HTML USING C#

Hi All,

I have a requirement of saving Excel files as HTML using C#. I have
managed to write code for saving as HTLM file. however this seems to be
not working in the once perticular case .

For e.g I hav the following values are in column say A1 & A2.

D  B
B  O
A  N
G  D
V  V
A  A
L   L

0   1
1   2
1   1

When I save this as HTML, I am getting saved file as  below ( Note the
change vertical display to horizontal)  . Any suggestions / comments on
this is highly appreciated. Thanks a lot for your time.

0 1
1 2
1 1


4/7/2006 12:23:21 PM
excel 39879 articles. 2 followers. Follow

0 Replies

Similar Articles

[PageSpeed] 4


Similar Artilces:

Code Bloat/Growing Excel files?

Test file needed quickly
Does anyone know where I can get a very large testt excel file that has a running macro? What I need to do is to run several apps that will "drain" most of my resources. I need to test another app in how it will handle low resources. I was thinking someone might have a test file just for this reason. A large spreadsheet that has a macro doing some calculations, at the same time while other apps are running. Thanks ahead for any help or suggestions. You realize if you fill a cell and then copy it to the rest of the sheet, it get really big, really fast? Dave wrote: > Doe...

ayuda con formula excel
quiero saber se me puede ayudar en eso praticamente yo quiero una formula da enserir an la celda CANCELLARE (mira foto para entender) [img=] que quando uno presiona la tecla CANCELLARE se borre todo el contenido de la linea detras de CANCELLARE o vero ( C9-D9-E9-F9-G9-H9 ) y trambien se tendrian que borrar en la hoja (tabla de datos ) donde estan lo mismo valore de ( C9-D9-E9-F9-G9-H9 ) o vero ( A7-B7-C7-D7-E7- F7-G7 )( mira la foto abajo )

Using word templates as email
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I want to ask how I use a word template as an email template? I have found an easy solution for PC on MS own website but it does not apply for Mac...I know this must be straightforward but simply select-all, cut, paste into new message does not work and template falls !!!! You can't do that in Microsoft Office for Mac. You have to write the email in Word then use File>Send to>Mail recipient (as HTML) from inside Word. It still makes a mess of it. Best to simply forget about it: ...

FileNotFound returned by Bitmap::Save() when saving to stream
I have a little chunk of code which is supposed to take a bitmap image and save its PNG encoding into a block of memory. The problem is, I keep getting a FileNotFound error back from Save(). If anyone has any ideas, I'd love to hear them. Here's the code (more or less) in question; there really shouldn't be much to it, I would have thought: /* Allocate an IStream object to write the data into a global memory block. We indicate that the handle to the underlying data will be freed when the stream object is released. */ VERIFY(S_OK == ::CreateStreamOnHGlobal(nil, True, static_c...

I cannot send a fax from excel, I always get a line busy message.
I am using win xp and I am trying to send a fax with excel. I go to file chose print, pick fax driver and then fax wizard comes up, I enter phone number in wizard and click finish but I always get a line busy message in the fax monitior, can anybody help me. Thanks , Dan ...

Excel window keeps changing
Hi, I have a weird problem on my home computer while using Excel. If I don't use the screen for a few minutes, the Excel window shrinks to about a fourth of its size. So I have to click it again to either Maximize or resize to about 90% full size, which I prefer using. It is by no means a fatal fault, but verry annoying! Any pointers? Amer ...

Handling of savings accounts and 401k accounts in the budget
I noticed that Money treats money that I contribute to a 401k account or transfer to a savings account as an expense. Basically, the more I contribute, the worse my budget looks. Is there a way to prevent this from happening? Right now, I exclude transfers to my savings account from the budget and it solves the problem, however, I shouldn't have to manually do this each time. For 401k contributions, I cannot find a way to do this. Why does it show up as "an expense" (what Category???) instead of something like Transfer Out of Budget Accounts? The 401k cash account sh...

what encoding does path) use to save the xml document if there is no <?xml... in the front of the xml document?
what encoding does path) use to save the xml document if there is no <?xml... in the front of the xml document? Daniel wrote: > what encoding does path) use to save the > xml document if there is no <?xml... in the front of the xml document? UTF-8 is the default encoding. -- Oleg Tkachenko [XML MVP, MCPD] | http://www.XmlLab.Net | http://www.XLinq.Net utf8 i suppose would be default Vinu Baby "Daniel" <> wrote in message news:e8#...

Unable to save password in Outlook 2003
I cannot seem to save my "network password" for Outlook 2003. I tried everything I can think of. I tried editing the registry. I use XP. I try going into Control Panel, go to mail and go thru the process there and....nothing worked there. I uninstalled Office the reinstalled it.....nothing! I even went as far as unistalling my internet software, still...nothing! Someone told me that XP will not save passwords. My Outlook express works fine. Someone HELP! I also had this issue in Outlook 2003, but also in indows Live Messenger and Internet Explorer 7. I spend hour...

Save and save as
Hi, I am looking for some help with a macro, I need to disable anyone from saving a file or save as and also disable the prompt if the close button is pressed you get an option to save the file then, I need to disable all of these, also have a pop up box to warn that save as been disables when a user tries to save the file fro save and save as. Can anyone help me with this. I am using word 2003 Regards Mark Once you give someone access to a document, you have ceded all control over it. You can however stop them from overwriting the original file by making the doc...

Excel 2008 hanges when deleting cells or rows
Anyone know of a problem with Excel 2008 hanging when deleting? I have a large spreadsheet with all my banking history in it Today after doing a statement download to a .csv and then cutting and pasting into the spreadsheet I tried to delete a few repeated lines and got an hourglass. Eventually I had to kill off Excel. I repeated the cut and paste then did the same delete and had exactly the same problem. deleting just a single cell does the same. Next time I saved after the paste, shut down Excel and restarted again, same problem. I can navigate around the sheet OK, edit cells OK, but as soon...

How can I mark rows in Excel so I can use this information to set.
It used to be so simple when I had used a database in Microsoft Works. Now I have an XP, had to get my address databases changed to Excel (by an online company) and I'm not up to snuff on how to work with this now. I'd like to mark certain addresses so I can pull them out for a partial mailing. Can this be done in Excel? I'm a 63-yr-old grandma, no formal training on the computer, have learned and am learning everything the hard way. Hi assuming that you have headings (like name / address etc) across row 1 and your data starts in row 2 then in in a column at the end of yo...

Dos command for Excel
Hi, Is there Dos command to support Excel files? Thanks. Molly Molly Kay wrote: > Is there Dos command to support Excel files? Well, you can use COPY to copy an Excel file, or ERASE to erase it, but this isn't what you have in mind, I'm sure. What are you trying to accomplish? ...

Saving Images
When I right click to save an image in an email, it will only save as a .bmp. I need to use it as a .jpeg or a .gif. How can I fix this? In, Angi <> typed: > When I right click to save an image in an email, it will only save as > a .bmp. I need to use it as a .jpeg or a .gif. How can I fix this? Clear your internet explorer temp file cache.....go to control panel, internet options, and choose 'delete files' "Angi" <> wrote in message...

Accessing Excel files over network
Hi Guys, First time here, so go easy on me. Scenario: Basic Windows 2000 Server based network with about 20 work stations connections. Server is a DC and workstations are all running Windows XP Pro. Workstations are also running Office XP. Users have deposited common files in a folder on the server. Because of control measures, these excel folders and files need to have permissions defined for either full control of read only access for certain members of the dept. Eg would be Folder Full Control Read-only Folder A Employee 1 Employee 10 ...

C++ Automation of excel
Where are the constants being used in the xl constants (such as xlPasteAll) listed that I can use them in VC++ automation code? or is there an include library that I can pull in to the code? Thanks in advance. create your own enum that looks like this: Look under xlPasteTypes AliR. "Ven" <> wrote in message > Where are the constants being used in the xl constants (such as xlPa...

Excel loses linked workbook
I have an error (or don’t understand the workings of the new version of excel). I have a workbook G:\2009\Monthly Reporting Working Files\P05\Trial Balance\YTD Financials.xlsx. This workbook is linked to the period 04 version workbook (G:\2009\Monthly Reporting Working Files\P04\Trial Balance\YTD Financials.xlsx). Note it is has the same file name but is held in a different location. It links to cell D47 of period 4 and then adds current month. The formula works ok but when I save the document the links get broken and the cells become a circular reference. I can’t understand why. I ha...

"Unattainable" savings goals
I've learned to mostly ignore it, but it drives me batty. I have a particular loan with a goal to pay it off by 7/4/04. The loan balance is 14,000. I have marked a savings account to be "used for budgeted savings goals." I deposit $1300 per month into the account which has a balance currently of $13000. Money 2K4 says that I cannot reach my savings goal. What can I do to help fix this? Any feedback would be appreciated! ...

Recalculate in Excel mobile?
In Excel on my PC, I can press F9 to recalculate - to re-roll a virtual dice, in this case. My PDA doesn't have an F9 key, and I can't spot anything obvious on the menus. Suggestions? I've now tried creating an ActiveX control - a button that calculates. Works fine on the PC, doesn't even appear in Excel Mobile. Not really any surprise, I suppose. Tools>Option>Calculation tab, Calculate Now? I don't know Excel Mobile. Can you record a macro to do that? -- Kind regards, Niek Otten <> wrote in message news:1135260390.867070.12353...

Text-to-speech in Excel X
I've been reading about Excel X having the ability to "read" text in=20 selected cells. Mac has the capability in Text Edit and the PC world = has=20 a "voice" option under the view+toolbars, but Mac doesn't. Any ideas? Thanks! ...

Saving default tabs
I can't seem to get a change in the default tab setting to save. When I reopen publisher the tab setting reverts to .5 which was original default. I'm I the only person who is having this problem? I'm using the 2003 verson but had the same problem with 2000. Why not take the default page, set the tabs you want and save it as a template with a file name of, "My Very Special Tabs Settings for Future" (jerking your chain a bit<G>) Then when you want to create what you want, use your created template file and when your pub file is what you want, do a Sa...

EXCEL #153
EXCELL - CAN ONLY ENTER 15 DIGITS, ENTERING MORE SHOW ZERO'S?? Please do not post with CAPS Lock on it is hard to read and considered rude. You should check your HELP and look up "specification limit" these are limitations built in or limitations that Excel must work with. You should not be using a numeric field for a credit card number for instance because it is not treated arithmetically, you should be using identification information at text. When you enter a 16 digit credit card 'number' the first 15 digits are the most significant digits and will be retai...

Save to unProtect a Document?
Our company has word documents that we use as templates on a fileserver. How could I protect the documents so that when they open them, they dont make changes to the server version, but save their OWN version and do what they want? First of all, make use of true *template* files (with the *.dot or *.dotx extension). Also, assign the template files the read-ony attribute. -- Stefan Blom Microsoft Word MVP "Chris" <> wrote in message > Our company has word docum...

PST file import to windows mail
I have chage my PC and I cannot import the PST outlook file in to my new windows Mail so far A error message appaer when I try to import a outlook message. Is someone have an idea regarding this issue Thanks Philippe You need outlook installed and configured on the Vista PC before you can import There is a workaround, assuming the old pc with outlook on is still available. You export your mail to outlook express, then copy the outlook express msg store to the Vista PC, then Mail can import it. Or you download the Office trial, with outlook, connect your pst as default to outlook, ...