Excel format problem

Question

HI, when i am exporting to excel, in the cells where data comes, that particular cell format is getting changed, please suggest a solution. Regards Navnith

Suthish Nair · Answer

what data you exporting to excel whose format getting changed, date? Then try like this: select '''' + convert(varchar, getdate(), 101)

nav nith · Answer

WRAPPING of text is going when data comes to that cell

nav nith · Answer

Hi dinkar, iam able to export to excel, but the problem is when data comes in that cell, that cell format is getting changed

Dinkar Chavhan · Answer

Normal 0 false false false EN-US X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable{mso-style-name:"Table Normal";mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-qformat:yes;mso-style-parent:"";mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin-top:0in;mso-para-margin-right:0in;mso-para-margin-bottom:10.0pt;mso-para-margin-left:0in;line-height:115%;mso-pagination:widow-orphan;font-size:11.0pt;font-family:"Calibri","sans-serif";mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-fareast-font-family:"Times New Roman";mso-fareast-theme-font:minor-fareast;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-font-family:"Times New Roman";mso-bidi-theme-font:minor-bidi;} Step 1: Open Visual Studio > File > New >Website > Under Templates, click ASP.NET WebSite and choose either Visual C# or Visual Basic as the language. Select a location and click Ok. Step 2: We will create two excel sheets and add them to the project. One excel sheet will be created in Office 2003(.xls) and the other one using Office 2007(.xlsx). Add 4 columns called EID, EName, Age and City to the 'Sheet1'. Also add some data into the columns. Once these excel files are created, add them to your project. To add them to the project, right click project > Add Existing Item > Add the two excel files. Step 3: We will now create a web.config file to store the connection string information. Right click project > Add New Item > Web.config. Add the following entries to the file connectionStrings > add name = " xls " connectionString = " Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Sample1.xls;Extended Properties=Excel 8.0 " /> add name = " xlsx " connectionString = " Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Sample.xlsx;Extended Properties=Excel 12.0 " /> connectionStrings > As you can observe, the connection string for xlsx (Excel 2007) contains Microsoft.ACE.OLEDB.12.0 as the provider. This is the new Access database engine OLE DB driver and is also capable of reading Excel 2003. Step 4: Add a GridView to the Default.aspx page. We will extract data from the excel file and bind it to the GridView. Step 5: Let us now create a connection to the excel file and extract data from it. Before that add a reference to System.Data.OleDb namespcae; Code followwing { protected void Page_Load( object sender, EventArgs e) { OleDbConnection cn = new OleDbConnection ( "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" +Server.MapPath( "sample.xlsx" )+ ";" + "Extended Properties=Excel 12.0;" ); cn.Open(); OleDbDataAdapter da = new OleDbDataAdapter ( "select * from [Sheet1$]" , cn); DataSet ds = new DataSet (); da.Fill(ds); GridView1.DataSource = ds.Tables[0].DefaultView; GridView1.DataBind(); }

Excel format problem

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (4)