在導(dǎo)出時(shí)使用 C# 將 Excel 列格式設(shè)置為十進(jìn)制

使用 C# 將數(shù)據(jù)從數(shù)據(jù)庫(kù)導(dǎo)出到 Excel 時(shí)，可能會(huì)遇到問題數(shù)字列的格式不正確。特別是，小數(shù)值可能會(huì)顯示為整數(shù)，而不是顯示小數(shù)位。

要解決此問題并確保正確導(dǎo)出小數(shù)列，您可以使用以下方法將小數(shù)格式添加到Excel 文件：

private static void ExportToExcel(DataTable dt, string FileName)
{
    // Create an ExcelPackage object.
    using (ExcelPackage excelPackage = new ExcelPackage())
    {
        // Add a new worksheet to the package.
        ExcelWorksheet ws = excelPackage.Workbook.Worksheets.Add(FileName);

        // Load the data from the DataTable into the worksheet.
        ws.Cells["A1"].LoadFromDataTable(dt, true);

        // Autofit the columns to accommodate the data.
        ws.Cells[ws.Dimension.Address].AutoFitColumns();

        // Iterate through the columns and apply decimal formatting to the desired ones.
        for (int col = 1; col <= ws.Dimension.End.Column; col++)
        {
            // Get the cell in the first row (header row) of the column.
            var cell = ws.Cells[1, col];

            // If the column contains numeric data, apply decimal formatting to it.
            var columnType = dt.Columns[col - 1].DataType;
            if (columnType == typeof(decimal) || columnType == typeof(double))
            {
                // Set the number format to two decimal places.
                cell.Style.Numberformat.Format = "0.00";
            }
        }

        // Convert the ExcelPackage object to a byte array.
        byte[] bin = excelPackage.GetAsByteArray();

        // Send the byte array to the browser for download.
        Response.ClearHeaders();
        Response.Clear();
        Response.Buffer = true;
        Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
        Response.AddHeader("content-length", bin.Length.ToString());
        Response.AddHeader("content-disposition", "attachment; filename=\"" + FileName + ".xlsx\"");
        Response.OutputStream.Write(bin, 0, bin.Length);
        Response.Flush();

        // Complete the request and clean up.
        HttpContext.Current.ApplicationInstance.CompleteRequest();
    }
}

此方法接受 DataTable 和文件名作為參數(shù)。它創(chuàng)建一個(gè) ExcelPackage 對(duì)象并將數(shù)據(jù)加載到其中。然后，代碼迭代每一列并檢查它是否包含數(shù)字?jǐn)?shù)據(jù)。如果是，則數(shù)字格式設(shè)置為“0.00”以確保顯示兩位小數(shù)。最后，ExcelPackage被轉(zhuǎn)換為字節(jié)數(shù)組并作為附件發(fā)送到瀏覽器。

以上是使用C#導(dǎo)出數(shù)據(jù)時(shí)如何正確格式化Excel小數(shù)列？的詳細(xì)內(nèi)容。更多信息請(qǐng)關(guān)注PHP中文網(wǎng)其他相關(guān)文章！