Export to Excel using String Builder for DataSet

Question

0.00/5 (No votes)

See more:

Is is possible to set the border for the cell and width of the column
when the string builder used for export to excel using data set in c#. and How ?
I am using sb.AppendFormat method.
Thanks in advance for quick Response.

Posted 18-Dec-12 2:58am

umesh bugade

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Zoltán Zörgő** · Answer 1 · 2012-12-18T03:06:00

StringBuilder can not export to anything, it is for string building. That's all. AppendFormat[^] is not for cell styling or anything that like.
- If you build a CSV file for example, than you can not add any styling.
- You can use OpenXML format if you have Excel 2007 and above or FileFormatConverters on Excel 2003: http://closedxml.codeplex.com/[^]
- A simple trick is to make a html with a styled table in it and name it xls. Excel will open seamlessly. (You might get a warning, but that's all)
- You can use Excel-XML format also: http://www.openscope.net/2010/02/09/transforming-xml-into-ms-excel-xml/[^]

anantha1434 · Answer 2 · 2013-05-07T18:02:00

Here is the solution for exporting the data displayed in stringbuilder to excel sheet.
This code is working perfectly. I am already integrate and i am using this code also.
It will help you for getting correct output.
Check this link:
http://www.dotnetspider.com/resources/38216-Create-Excel-File-using-ASP-NET-C.aspx[^]

Export to Excel using String Builder for DataSet

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0