• 0

[c# .net] Converting a csv to an xls document


Question

Hey guys,

I'm thinking of developing a script for work, which basically allows any csv to be converted into a xls document.

How would i go about doing this, I can only seem to find details on how to convert xls to csv.

Is this a Big task to take on?

thanks

matt

1 answer to this question

Recommended Posts

  • 0

Well, you could do it a couple of ways:

1). If it is a client application and the user as Microsoft Excel installed, you can use the Excel COM objects to write to the file.

2). Regardless of environment (client or server), you could use the Microsoft JET OLEDDB provider to write to the file in a SQL like manner.

3). If you are doing it in a web application (ASP.NET), you could simply convert the CSV file into a HTML table, and write out the response stream as ContentType "application/vnd.ms-excel"

The last option does afford you limited formatting options, as Excel does respect any styling you've applied in HTML/CSS (to its best ability).

Does that help?

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • The long-awaited Nothing Phone (3) is finally coming next month, launch date confirmed by Aditya Tiwari London-based consumer electronics brand Nothing is due to launch its latest flagship in 2025. The company dropped a new teaser for the Phone (3), revealing when the flagship device will be out on the market. Nothing Phone (3) will be unveiled during a live event on July 1 at 1:00 PM ET / 10:00 AM PT / 6:00 PM BST / 11:30 PM IST. It has already created a live event titled "Come to Play" on its official YouTube channel, for which you can add a reminder by clicking on the "Notify Me" button. Nothing CEO Carl Pei has previously dropped several details about the unreleased smartphone. He took part in a social media AMA earlier this year and said Nothing Phone (3) will arrive in the third quarter of 2025. Pei confirmed that Nothing Phone (3) will make its way to the US this time after a dry spell since 2023. However, he didn't specify whether the device will be sold directly or through the beta channel, which currently includes Phone (3a), Phone (3a) Pro, and CMF Phone 2 Pro. The US has been a rocky terrain for Nothing. Its first smartphone was made available through the beta channel, and the Nothing Phone (2) is the only smartphone from the company that has been widely available in the US. The Glyph interface featured on the back of Nothing smartphones has remained a differentiating factor from the start. However, the smartphone maker recently posted a 9-second video in which the Glyph lights on the back of a Nothing smartphone abruptly turn off. "We killed the Glyph Interface," the company said. It makes sense when you check out the Phone (3) teaser and see dot matrix-style lights being flashed in a pattern. Nothing released another teaser about a week ago, featuring the number 3 lit up as dot matrix LEDs. If you're looking for some trivia, Nothing product manager Raymond Zhu estimated in a Q&A video that the company would need to sell about 250,000 Phone (3) units to turn a profit. Answering another question, he added that their biggest weakness is "no one knows us", and the company is struggling to reach the masses without high marketing budgets. Let's wait to see what Nothing has in store for Phone (3) next month other than the new physical button. Speaking of the future of smartphones, the Nothing CEO believes that our entire software experience will eventually be condensed down to just one app.
    • As far as I can remember, no one has done a 4v4 before. 2v2? yes. 3v3? yes.
    • I just checked with Brave portable, the shield is disabled, as well as uBlock Origin Lite, no change to the Host file, and no pop-up when I connect to the site 😵! I think this might be the best option? I don't have a Paypal account, because I got rid of it, and I was fed up with all the phishing attempts, so I use my credit card. Do you take credit card payments? Because so far it's been safer, no phishing attempts.    
    • *facepalm* Good sir... holy smokes. ...anyways I assume Qanba and the rest will also produce options in the near future.
  • Recent Achievements

    • Week One Done
      jbatch earned a badge
      Week One Done
    • First Post
      Yianis earned a badge
      First Post
    • Rookie
      GTRoberts went up a rank
      Rookie
    • First Post
      James courage Tabla earned a badge
      First Post
    • Reacting Well
      James courage Tabla earned a badge
      Reacting Well
  • Popular Contributors

    1. 1
      +primortal
      403
    2. 2
      +FloatingFatMan
      179
    3. 3
      snowy owl
      174
    4. 4
      ATLien_0
      170
    5. 5
      Xenon
      135
  • Tell a friend

    Love Neowin? Tell a friend!