Click here to Skip to main content
15,891,513 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi everyone,

I have one problem with formatting my data from html's table to excel because some items, it starts with 000 and number. so when i export, all 000 of items will delete automatically.
ex: item 000123455 in html's table but in excel 123455( if i change from General Mode to Text, in excel will keep 000123455). I have checked with <x:excelworksheets xmlns:x="#unknown"> or <x:worksheetoptions> and i don't see property or method that can format this item to text.

So does anyone know how i can do or change from General to Text while i exporting?

Thanks

TONY
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900