Trying to understand C# and XML Spreadsheets in ASP.net -



Trying to understand C# and XML Spreadsheets in ASP.net -

i'm building web application give users same info see on table on current page, in excel spreadsheet format. found previous code in project did same thing.

small question first: know how column ss:width works? it's not exact match. column ss:autofitwidth="0" ss:width="114" returns column width of 21.00...

where i'm having of problem is, of info passed spreadsheet has leading , tailing whitespace; have no thought how remove it. i've tried .trim() when create .tostring() query , i've been looking other methods, haven't seemed find it. next snippet of worksheet code:

<worksheet ss:name="usermgmt1"> <table> @*name*@ <column ss:autofitwidth="0" ss:width="114" /> <row> <cell ss:styleid="s29"> <data ss:type="string">name</data> </cell> </row> @foreach (tbl_users query in viewbag.contents ) { <row> <cell ss:styleid="s31"> <ss:data ss:type="string" > @(query.name.tostring().trim()) </ss:data> </cell> </row> } </table> </worksheet>

forgot add together actionresult implements code:

public actionresult _excel(tblusers model) { list<tbl_users> inquirieslist = usermanagemodel.getresults(model); viewbag.contents = inquirieslist; homecoming view("_excel"); }

and call:

@using (html.beginform("_excel", "usermanage", formmethod.post)) { <input type="submit" value="view detailed list of users in excel" /> }

the result looks in excel, much whitespace surrounding each string item:

administrator

according xml excel spec on msdn http://msdn.microsoft.com/en-us/library/aa140066(v=office.10).aspx#odc_xmlss_ss:column ss:width column width in points (which may render differently based on screen resolution, etc).

the spaces around trimmed text may due indenting. seek collapsing xml element this:

<ss:data ss:type="string" >@(query.name.tostring().trim())</ss:data>

c# asp.net-mvc-3 xml-spreadsheet

Comments

Post a Comment

Popular posts from this blog

web services - java.lang.NoClassDefFoundError: Could not initialize class net.sf.cglib.proxy.Enhancer -

web services - java.lang.NoClassDefFoundError: Could not initialize class net.sf.cglib.proxy.Enhancer - when trying request rest service @ time of response getting exception.. feb 21, 2013 2:34:49 pm com.sun.jersey.spi.container.containerresponse mapmappablecontainerexception severe: exception contained within mappablecontainerexception not mapped response, re-throwing http container java.lang.noclassdeffounderror: not initialize class net.sf.cglib.proxy.enhancer @ org.hibernate.proxy.pojo.cglib.cgliblazyinitializer.getproxyfactory(cgliblazyinitializer.java:117) @ org.hibernate.proxy.pojo.cglib.cglibproxyfactory.postinstantiate(cglibproxyfactory.java:43) @ org.hibernate.tuple.entity.pojoentitytuplizer.buildproxyfactory(pojoentitytuplizer.java:162) @ org.hibernate.tuple.entity.abstractentitytuplizer.<init>(abstractentitytuplizer.java:135) @ org.hibernate.tuple.entity.pojoentitytuplizer.<init>(pojoentitytuplizer.java:55) @ org.hibernate.tuple.e...
Read more

Accessing MATLAB's unicode strings from C -

Accessing MATLAB's unicode strings from C - how can access underlying unicode info of matlab strings through matlab engine or mex c interfaces? here's example. let's set unicode characters in utf-8 encoded file test.txt, read as fid=fopen('test.txt','r','l','utf-8'); s=fscanf(fid, '%s') in matlab. now if first feature('defaultcharacterset', 'utf-8') , c engevalstring(ep, "s") , output text file utf-8. proves matlab stores unicode internally. if mxarraytostring(enggetvariable(ep, "s")) , unicode2native(s, 'latin-1') give me in matlab: non-latin-1 characters replaced character code 26. need getting access underlying unicode info c string in unicode format (utf-8, utf-16, etc.), , preserving non-latin-1 characters. is possible? my platform os x, matlab r2012b. addendum: documentation explicitly states "[mxarraytostring()] supports multibyte encoded characters...
Read more

javascript - mongodb won't find my schema method in nested container -

javascript - mongodb won't find my schema method in nested container - i trying access method of schema stored within mixed container. here situation : have cases model can many different things, have schema each of these things stored in "casecontent" mixed property. var caseschema = mongoose.schema({ casecontent : {}, object : {type:string, default : "null"}, collision : {type : boolean, default : false} }); the casecontent property filled model of 1 of schemas, 1 exemple : var treeschema = new mongoose.schema({ applecount : {type : number, default : 3} }); treeschema.methods.dostuff = function (data) { console.log('hey, listen'); homecoming true; }; then, want utilize method of schema original container : caseschema.methods.dostuff = function (data) { if (this.casecontent.dostuff !== undefined) { this.casecontent.dostuff(); console.log('it worked'); } else { ...
Read more