Follow-up problems after DataGridView is imported into Excel

流氓法师

How about you create a template, change the format to text, and then write it in with your original program.

5风随心动

worksheet.get_Range(xlApp.Cells[1, 3], xlApp.Cells[10, 3]).NumberFormatLocal = "000000000000";//Set the cell format here for 3 columns and rows 1 to 10 are displayed as 12 digits Numbers, fill in the missing positions with 0

自由得很无力

to:5风随心动

Your method is to call the com method, I am now using stream to read and write. Thank you!