vb.net - NPOI Format Number As Text -


i'm trying generate excel file using vb in visual studio 2010, using npoi library. ran issue data inserted format incorrectly.

for example, have user id "0001", , i'm trying inserted excel. in output excel file, cell says "1" incorrect. looked @ format , says "text" , not "general".

how can go inserting "0001" correctly instead of "1"?

i tried , it's no making changes

mystyle.dataformat = hssfdataformat.getbuiltinformat("text") 

i tried "@" , doesn't make changes.

any appreciated.

make sure set celltype string if don't already.

celltype = npoi.ss.usermodel.celltype.string; var cell=currentrow.createcell(i, celltype);


Comments

Popular posts from this blog

matlab - "Contour not rendered for non-finite ZData" -

delphi - Indy UDP Read Contents of Adata -

javascript - Any ideas when Firefox is likely to implement lengthAdjust and textLength? -