CodeVerge.Net Beta


   Explore    Item Entry    Members      Register  Login  
NEWSGROUP
.NET
Algorithms-Data Structures
Asp.Net
C Plus Plus
CSharp
Database
HTML
Javascript
Linq
Other
Regular Expressions
VB.Net
XML

Free Download:




Zone: > NEWSGROUP > Asp.Net Forum > visual_studio.visual_studio_2005 Tags:
Item Type: NewsGroup Date Entered: 4/26/2007 1:39:18 PM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
(NR, 0)
XPoints: N/A Replies: 2 Views: 46 Favorited: 0 Favorite
Can Reply:  No Members Can Edit: No Online: Yes
3 Items, 1 Pages 1 |< << Go >> >|
theOr1ent
Asp.Net User
Exporting Unicode Data to Excel within Visual Studio 20054/26/2007 1:39:18 PM

0/0

Hi.

I have a database of names, some of which contain Polish and German charactersets, and I want to allow the facility to export data into Excel.

Is there a way of doing this that maintains the integrity of the non-Western characters? I have seen several examples, yet the result consists of strange escape characters. The work around is to open in a CSV format and re-save in Unicode format- but this is unacceptable for our users.

I have been told that Excel can be a difficult proposition but wondered if anyone had achieved this in .NET 2.0?

Many Thanks.

Lee.

smiling4ever
Asp.Net User
Re: Exporting Unicode Data to Excel within Visual Studio 20054/26/2007 1:57:15 PM

0/0

Hi,

www.codeproject.com

There is an article there about this.

 

HTH 

Benson Yu - MSF
Asp.Net User
Re: Exporting Unicode Data to Excel within Visual Studio 20054/30/2007 5:10:24 AM

0/0

Hi Lee,

 

The CSV file is just a txt file. You can open it by notepad.exe. So if we want to save the file with Unicode data, we should set the encoding of IO stream to Unicode. For example:

 

System.IO.StreamWriter sw = new System.IO.StreamWriter(fs, System.Text.Encoding.Unicode);

 

For more detailed information and sample code please access this link:

 

How to transfer data to an Excel workbook by using Visual C# 2005 or Visual C# .NET

http://support.microsoft.com/kb/306023

 

 


Sincerely,
Benson Yu
Microsoft Online Community Support

Please remember to click ?Mark as Answer? on the post that helps you, and to click ?Unmark as Answer? if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
3 Items, 1 Pages 1 |< << Go >> >|


Free Download:

Books:
Hands-on Microsoft SQL Server 2005 Integration Services: Essential Skills for Database Professionals Authors: Ashwani Nanda, Pages: 570, Published: 2006

Web:
Exporting Unicode Data to Excel within Visual Studio 2005 - ASP ... Exporting Unicode Data to Excel within Visual Studio 2005. Last post 04-30-2007 1:10 AM by Benson Yu - MSFT. 2 replies. Sort Posts: ...
Reading/Writing XLS/CSV/HTML/XLSX files with GemBox.Spreadsheet ... Read or Write Microsoft Excel files without Excel from your C#, VB, ASP.NET Applications. ... NET 2003, Visual Studio 2005 and Visual Studio 2008.
Exporting report to Excel in Single Page View - SQL Server - If you have Visual Studio installed, it should be under %ProgramFiles%\Microsoft Visual .... OPENQUERY and unicode from MySQL Hi, all. Using SQL 2005. ...
microsoft corp. and microsoft excel and software development ... You can export data into MS Access, MS Excel, MS Word RTF, HTML, XML, PDF, TXT,. ... MSDN Webcast: Using Data in Excel Solutions Built With Visual Studio ...
CodeProject: Exporting DataGrid to Excel, Word and Text Files ... NET, Visual Studio, ASP.NET, ADO.NET, WebForms, Dev Posted: 21 Jul 2005 ..... NET component for importing/exporting data to Excel files (XLS, XLSX, ...
EMS SQL Manager - SQL Server Tools - EMS Data Export for SQL Server Now you are able to export Unicode data; Now you can use parameters in data .... Now you can add notes and hyperlinks to the Excel documents you create ...
Data Entry / .NET WinForm NET tools work natively within Visual Studio 2005 and 2008 and include Office ... as well as Application Styling, Excel import/export, and a Document Export ...
How to transfer XML data to Microsoft Excel 2002 or Microsoft ... Describes some sample steps for how to transfer XML data to Microsoft Excel 2002 by using Visual C# 2005 or Visual C# .NET.
.NET DB-Aware > DB Access > Export and Import. Torry's Delphi Pages NET Edition supports Visual Studio .NET 2005 and 2008, Windows. ... NET component suit for data export into MS Excel, MS Word, HTML, XML, PDF, MS Access , ...
p2p.wrox.com Forums - Exporting data from a repeater to an Excel sheet NET 1.x and 2.0 Application Design > Exporting data from a repeater to an .... Silverlight, Visual Studio 2005, Visual Studio 2008, VS. ...




Search This Site:










using network account in web.config

how does the "public" attribute work on photo albumns

am i designing this right?

i really don’t know when it’s good practice to create a component class

hosting windows control on web page

iis 6 - auto forward http to https?

start up from scratch

how to open a winform in asp.net?

portal banner

change querystring in formate

parser error

encryption - decryption, any links?

accessing global class

db installation

best way to handle communication between modules

just an idea.delete all recycle bin

adding groups to the membership model

code re-use in asp.net

rendercontrol() problem.....

asp clasic to asp.net

new free module for dnn 3.1

cannot log into portal after install

composite control and client ids

administration problem - logging out automatically

build solution

asp.net and mcms dll access issue

dnn1.0.10 error converting data type nvarchar to datetime.

using css with the menu control

any standard way of user account creation and management

problem with verbatim string

 
All Times Are GMT