0

I use DataTable for export data to excel, but the final file doesn't show well data sized more than 10 caracters.

enter image description here

for example the value 1,65987E+11 is recorded in database and in code "165987000501" as string So is there any solution for inscrease the cell size for show more numbers ? Regards.

Improve this question
6
  • Enclose the value in quotes, so Excel knows to treat it as a string and not a number. Commented Feb 12, 2019 at 10:55
  • Another option would be changing cell format to Number with 0 decimals. Commented Feb 12, 2019 at 11:08
  • how do you export to excel ? Commented Feb 12, 2019 at 11:44
  • this link stackoverflow.com/questions/16346227/… @patel Commented Feb 12, 2019 at 12:00
  • and which option could use for set length , i tried many ways without result Commented Feb 12, 2019 at 15:34
Related questions
1
ASP.NET: TableCell size problem
2
How to set the size of DataGridView VB.net
0
how to size row to fit with datagridview size in vb.net
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.