I have a to save a file to_excel But the fist column has 15 digits in it and in Excel is showing as 31100000+13 something in want this to show as number itself how do I do that. writer = pd.ExcelWriter(‘test1.xlsx’, engine = ‘xlsxwriter’) df.to_excel(writer,’Sheet1′) workbook = writer.book worksheet = writer.sheets[‘Sheet1’] format1 = workbook.add_format({‘num_format’: ‘#’})… Read More I need to save a df to excel. First column has 15 digits so it is taking as scientific number; how to avoid that

I am trying to simply create an Excel sheet with lots of formatting in it from Access via VBA. With this example I’m just trying to select A1 to E1 and turn the color of the cells to the color blue with a left border to each cell yet nothing happens, the Excel file opens… Read More Formatting Excel Cells from Access Not Working