Click here to Skip to main content
15,897,273 members
Home / Discussions / C#
   

C#

 
Question[Message Deleted] Pin
venkat86_ece20-May-08 23:48
venkat86_ece20-May-08 23:48 
AnswerRe: Generate time table Pin
Gareth H20-May-08 23:59
Gareth H20-May-08 23:59 
AnswerRe: Generate time table Pin
originSH21-May-08 0:00
originSH21-May-08 0:00 
AnswerRe: Generate time table Pin
Christian Graus21-May-08 0:00
protectorChristian Graus21-May-08 0:00 
GeneralRe: Generate time table Pin
Spunky Coder21-May-08 0:11
Spunky Coder21-May-08 0:11 
GeneralRe: Generate time table Pin
J4amieC21-May-08 1:10
J4amieC21-May-08 1:10 
GeneralRe: Generate time table Pin
MumbleB21-May-08 2:21
MumbleB21-May-08 2:21 
QuestionExport to Excel File Size Issue Pin
rrprabu20-May-08 23:30
rrprabu20-May-08 23:30 
Hi,
I am writing a code in c# with asp.net 2003 for export to excel from Repeater Control.In this I am facing file size is very big than normal.It has 5000 rows also 120 Columns.In these around 60 Columns are containing text class(style Sheet).I got exported file size is 32 MB.But if I copy those rows from exported file and paste it into new file , the new file has only 5.2 MB.Even If i open the exported file and save as new copy ,Its also contains 5.2 MB only. How to Reduce my file size while exporting only.My code is
<br />
        string strFilePath="";<br />
	DateTime tTime = DateTime.Now;<br />
	strFilePath =  "ADSL"+tTime + ".xls";<br />
	strFilePath = strFilePath.Replace("/","");<br />
	strFilePath = strFilePath.Replace(" ","");<br />
	strFilePath = strFilePath.Replace(":","");<br />
	string serverpath = Request.PhysicalApplicationPath.ToString();<br />
	serverpath += @"ExcelFiles\";<br />
	if (!Directory.Exists(serverpath))<br />
	{<br />
		Directory.CreateDirectory(serverpath);<br />
	}<br />
	serverpath += strFilePath;<br />
	string style = @"<style> .text { mso-number-format:\@; } </style> ";<br />
	Repeater1.Items[0].Visible = true;<br />
	Response.Clear(); <br />
	Response.AddHeader("content-disposition", "attachment;filename=" +serverpath);<br />
	Response.ContentType = "application/vnd.ms-excel";<br />
	System.IO.StringWriter stringWrite = new System.IO.StringWriter();<br />
	System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);<br />
	Repeater1.RenderControl(htmlWrite);<br />
	Response.Write(style);<br />
	Response.Write(stringWrite.ToString());<br />
	Response.End();<br />




If anyone knows answers, Plz reply fast.This is urgent

Regards
prabu
QuestionStringBuilder ' escape sequence Pin
StyleGuide20-May-08 22:44
StyleGuide20-May-08 22:44 
AnswerRe: StringBuilder ' escape sequence Pin
Bekjong20-May-08 23:05
Bekjong20-May-08 23:05 
GeneralRe: StringBuilder ' escape sequence Pin
StyleGuide20-May-08 23:48
StyleGuide20-May-08 23:48 
GeneralRe: StringBuilder ' escape sequence Pin
Vikram A Punathambekar21-May-08 0:07
Vikram A Punathambekar21-May-08 0:07 
GeneralRe: StringBuilder ' escape sequence Pin
dan!sh 21-May-08 0:07
professional dan!sh 21-May-08 0:07 
GeneralRe: StringBuilder ' escape sequence Pin
StyleGuide21-May-08 0:19
StyleGuide21-May-08 0:19 
Questionchange text in .rtf file using c# code Pin
kamalesh574320-May-08 22:41
kamalesh574320-May-08 22:41 
AnswerRe: change text in .rtf file using c# code Pin
Christian Graus20-May-08 23:23
protectorChristian Graus20-May-08 23:23 
QuestionActive Accessibility thru c# / Getting FIrefox URL Pin
mihir raut20-May-08 21:35
mihir raut20-May-08 21:35 
QuestionHelp Needed With Popup Pin
sanchit_mum0720-May-08 21:33
sanchit_mum0720-May-08 21:33 
AnswerRe: Help Needed With Popup Pin
Christian Graus20-May-08 22:02
protectorChristian Graus20-May-08 22:02 
Questionhow to select event of controls Pin
please help20-May-08 21:02
please help20-May-08 21:02 
AnswerRe: how to select event of controls Pin
Mr.Kode20-May-08 21:06
Mr.Kode20-May-08 21:06 
GeneralRe: how to select event of controls Pin
please help20-May-08 21:20
please help20-May-08 21:20 
GeneralRe: how to select event of controls Pin
Nouman Bhatti20-May-08 21:31
Nouman Bhatti20-May-08 21:31 
GeneralRe: how to select event of controls Pin
Christian Graus20-May-08 23:24
protectorChristian Graus20-May-08 23:24 
Questionproblem with SQLparameter Pin
Mr.Kode20-May-08 20:47
Mr.Kode20-May-08 20:47 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.