Does anyone know if I can format excel cells from AIMMS? The data that I export contains date and excel automatically converts it to its own date format and changes the defaults AIMMS format. Is it possible to set it as string when writing?
Best answer by mohansxView original
Just set the value of this function as 1 before writing out data.
axll::KeepExistingCellFormats := 1
PublicSection — AIMMSXLLibrary documentation