troubleshooting Question
How to add " ' " when transferring DataGrid data to Excel?
asked on
Hi, Experts,
I would like to add " ' " in the excel cell to avoid zero missing for number format, for example (000123). I want whole number to be displayed in the excel cell, without " ' " in excel the number will become (123) only.
Previously, i add Section A code to add " ' " to get whole number displayed, but now is i cannot add " ' " for code in Section B.
Can any one tell me how to add " ' " before dr("No") ?
Thank you.
Best Regards,
--chkueh--
I would like to add " ' " in the excel cell to avoid zero missing for number format, for example (000123). I want whole number to be displayed in the excel cell, without " ' " in excel the number will become (123) only.
Previously, i add Section A code to add " ' " to get whole number displayed, but now is i cannot add " ' " for code in Section B.
Can any one tell me how to add " ' " before dr("No") ?
Thank you.
Best Regards,
--chkueh--
Section A:
Dim No As String = Trim(txtNo.Text)
excelWorksheet.Range("C4").Value = "'" & No
Section B:
.Range("B" & i.ToString).Value = dr("No")
.Range("B" & i.ToString).HorizontalAlignment = Excel.Constants.xlLeft
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.