Missing leading zeros

[psyhlo]

Excel Type

• XLSX
• XLSM
• CSV
• OTHER

Upload Excel File

Router.xlsx
result_0000045299.xlsx

MiniExcel Version

1.35.0

Description

When i try to export 0000045299 to cell {{LOT}} it written without leading zeros.

class ReportRouter
{
    public string ProductCode { get; set; }
    public string ProductName { get; set; }
    public string LOT { get; set; }
    public string SerNum { get; set; }
    public string REV { get; set; }
    public IEnumerable<Component> Components { get; set; }
}

class Component
{
    public string PartDesc { get; set; }
    public string PartCode { get; set; }
    public string PartRev { get; set; }
    public string PartLOT { get; set; }
    public string PartSN { get; set; }
    public string sProductionRowID { get; set; }
}

And one other when i have image attached to cell and insert data the table expands as it should but the image is not moved and stay in row 7 and must be on row 9

PS
If add ' in front of the number, i'm able to add the zeros but has do some manual work. Open file, click on cell and , to accept it as text and to hide '