sheetjs
/
sheetjs
24
Fork 25
Code Issues 176 Pull Requests 12 Wiki Activity

Issue While exporting File to Excel #3037

New Issue
Closed
opened 2023-11-28 05:59:32 +00:00 by rajufodse · 3 comments
rajufodse commented 2023-11-28 05:59:32 +00:00
Copy Link

I am using SheetJS in my MVC project to export HTML table (id="myTable") to Excel File. I am giving two space to some table column heading, But while exporting data I could not get extra space in excel file. How do I get Extra Space please guide and Thanks in advance. Following is my Code

@model EasyApp.Models.InvHead
@using EasyApp.Models


@{
    Layout = "~/Views/Shared/_LayoutExcise.cshtml";
}
<head>
    <meta name="viewport" content="width=device-width" />
    <title>Export Data</title>

    <link href="~/Content/bootstrap.min.css" rel="stylesheet" />
    <script src="~/DatatableBS/jquery.dataTables.min.js"></script>
    <script src="~/DatatableBS/dataTables.bootstrap4.min.js"></script>
    <link href="~/DatatableBS/dataTables.bootstrap4.min.css" rel="stylesheet" />
    @*<script src="~/Scripts/ExcelExportSheetJS.js"></script>*@
    <script src="https://cdn.sheetjs.com/xlsx-0.20.0/package/dist/xlsx.full.min.js"></script>

    <style>
        .barcode{
    white-space:pre; 
}
    </style>
</head>
<body>
    <div class="EasyViewHeader Raleway">Export eInvoice Data</div>
    <div class="EasyViewDiv">
        <div class="EasyViewContainer">


            <div class="col-md-12">
                <div class="card">
                    <div class="card-header">
                        <h5>Invoice No : @Model.InvRefID  (SYSID:@Model.InvID)</h5>

                    </div>
                    <div class="card-body">
                        <div class="form-group">
                            <button class="btn btn-outline-success" id="exportBtn">Export to Excel</button>
                            <button class="btn btn-outline-danger" onclick="ExportToExcel('xlsx')">Export Data to excel</button>
                        </div>
                        <div>
                            <table style="font-size:14px;" class="table table-bordered table-striped table-sm table-dark text-light">
                                <tr><td>Transaction Reference Number</td><td>@Model.InvID</td><td>External Reference Number</td><td></td></tr>
                                <tr><td>Supply Type</td><td>@Model.SupplyType</td><td>Project Reference Number</td><td></td></tr>
                                <tr><td>Invoice Reference Number</td><td></td><td>PO Date</td><td></td></tr>
                                <tr><td>Invoice Type</td><td>@Model.InvoiceType</td><td>Supporting Document URL</td><td></td></tr>
                                <tr><td>Invoice Number</td><td>@Model.InvRefID</td><td>Other Supporting Document</td><td></td></tr>
                                <tr><td>Invoice Date</td><td>@Convert.ToString(Model.InvDate.Value.ToString("dd-MM-yyyy"))</td><td>Any Other Additional Information</td><td></td></tr>
                                <tr><td>Invoice Value</td><td>@Model.GrandAmt</td><td>Total Invoice Value in Foreign Currency</td><td></td></tr>
                                <tr><td>Department Name</td><td></td><td>Option for Supplier for Refund</td><td></td></tr>
                                <tr><td>Department ID</td><td></td><td>Foreign Currency</td><td></td></tr>
                                <tr><td>PO Number</td><td></td><td>Customer Country Code</td><td></td></tr>
                                <tr><td>Transaction Type</td><td>@Model.TRNType</td><td>Total Taxable Value</td><td>@Model.TaxableAmt</td></tr>
                                <tr><td>Transaction Subtype</td><td>@Model.TRNSubType</td><td>Total IGST Amount</td><td>@Model.ItemIGSTAmt</td></tr>
                                <tr><td>Place of Supply</td><td>@Model.OMAddress.State.VechCode</td><td>Total CGST Amount</td><td>@Model.ItemCGSTAmt</td></tr>
                                <tr><td>Origin Country</td><td></td><td>Total SGST/UTGST Amount</td><td>@Model.ItemSGSTAmt</td></tr>
                                <tr><td>Org Code</td><td>@Model.OMAddress2.GSTCode</td><td>Total Cess Amount</td><td></td></tr>
                                <tr><td>Supplier Code</td><td></td><td>Total State Cess Amount</td><td></td></tr>
                                <tr><td>Supplier Location Code</td><td></td><td>Rounding Off Amount</td><td></td></tr>
                                <tr><td>Supplier GSTIN/UIN</td><td>@Model.OMAddress2.GSTCode</td><td>Discount at Invoice level</td><td></td></tr>
                                <tr><td>Buyer Code</td><td></td><td>Charges at Invoice level</td><td>@Model.OtherTaxAmt</td></tr>
                                <tr><td>Buyer Location Code</td><td></td><td>Flag for Supply covered under sec7 of IGST Act</td><td></td></tr>
                                <tr><td>Buyer GSTIN/UIN</td><td>@Model.OMAddress.GSTCode</td><td>Original Invoice Value</td><td>@Model.GrandAmt</td></tr>
                                <tr><td>Supplier PAN</td><td></td><td>Original POS</td><td></td></tr>
                                <tr><td>Reverse Charge</td><td>@Model.ReverseCharge</td><td>Original Transaction Type</td><td></td></tr>
                                <tr><td>Supplier Legal Name</td><td>@Model.OMAddress2.PartyName</td><td>Original Transaction ID</td><td></td></tr>
                                <tr><td>Supplier Trade Name</td><td>LALIT PIPES</td><td>Differential Percentage</td><td></td></tr>
                                <tr><td>Supplier Address1</td><td>SURVEY NO. 77, VILLAGE VARASKOL, KHARDI RLY. STN. (CR)</td><td>Supply Category</td><td></td></tr>
                                <tr><td>Supplier Address2</td><td>TALUKA SHAHPUR, DIST THANE, 421601</td><td>Line item ID</td><td></td></tr>
                                <tr><td>Supplier City</td><td>SHAHAPUR</td><td>Goods/Services</td><td></td></tr>
                                <tr><td>Supplier State</td><td>MH</td><td>HSN Code</td><td></td></tr>
                                <tr><td>Supplier PINCode</td><td>421601</td><td>Schedule Description Code</td><td></td></tr>
                                <tr><td>Supplier EmailID</td><td></td><td>HSN Description</td><td></td></tr>
                                <tr><td>Supplier Phone Number</td><td></td><td>Exemption Notification No</td><td></td></tr>
                                <tr><td>Buyer Trade Name</td><td></td><td>Compensation Cess Description Code</td><td></td></tr>
                                <tr><td>Buyer Legal Name</td><td>@Model.OMAddress.PartyName</td><td>RCM Description Code</td><td></td></tr>
                                <tr><td>Buyer Address1</td><td>@Model.OMAddress.Address2</td><td>Bar code of Product</td><td></td></tr>
                                <tr><td>Buyer Address2</td><td>@Model.OMAddress.Address3</td><td>Quantity</td><td></td></tr>
                                <tr><td>Buyer City</td><td>@Model.OMAddress.City</td><td>Free Quantity</td><td></td></tr>
                                <tr><td>Buyer State</td><td>@Model.OMAddress.State.VechCode</td><td>UQC</td></tr>
                                <tr><td>Buyer PIN Code</td><td>@Model.OMAddress.PinCode</td><td>Rate per Quantity</td><td></td></tr>
                                <tr><td>Buyer EmailID</td><td></td><td>GrossValue</td><td></td></tr>
                                <tr><td>Buyer Phone Number</td><td></td><td>Discount Before GST</td><td></td></tr>
                                <tr><td>Dispatch Code</td><td></td><td>Pre Taxable Value</td><td></td></tr>
                                <tr><td>Dispatch GSTIN</td><td>@Model.OMAddress2.GSTCode</td><td>Taxable Value</td><td></td></tr>
                                <tr><td>Dispatch Name</td><td>@Model.OMAddress2.PartyName</td><td>Batch Name</td><td></td></tr>
                                <tr><td>Dispatch Address1</td><td>@Model.OMAddress2.Address2</td><td>Warranty Date</td><td></td></tr>
                                <tr><td>Dispatch Address2</td><td>@Model.OMAddress2.Address3</td><td>Expiry Date</td><td></td></tr>
                                <tr><td>Dispatch City</td><td>@Model.OMAddress2.City</td><td>GSTRate</td><td></td></tr>
                                <tr><td>Dispatch State</td><td>@Model.OMAddress2.State.VechCode</td><td>Cess Rate</td><td></td></tr>
                                <tr><td>Dispatch PIN Code</td><td>@Model.OMAddress2.PinCode</td><td>State Cess Rate</td><td></td></tr>
                                <tr><td>Dispatcher EmailID</td><td></td><td>Cess Non Advol Value</td><td></td></tr>
                                <tr><td>Dispatcher Phone Number</td><td></td><td>IGST Amount</td><td></td></tr>
                                <tr><td>Ship Code</td><td></td><td>CGST Amount</td><td></td></tr>
                                <tr><td>Ship to Legal Name</td><td>@Model.OMAddress1.PartyName</td><td>SGST/UTGST Amount</td><td></td></tr>
                                <tr><td>Ship to Trade Name</td><td></td><td>Compensation Cess Amount</td><td></td></tr>
                                <tr><td>Ship to GSTIN</td><td>@Model.OMAddress1.GSTCode</td><td>State Cess Amount</td><td></td></tr>
                                <tr><td>Ship to Address1</td><td>@Model.OMAddress1.Address2</td><td>State Cess Non Advol Amount</td><td></td></tr>
                                <tr><td>Ship to Address2</td><td>@Model.OMAddress1.Address3</td><td>Other Charges</td><td></td></tr>
                                <tr><td>Ship to City</td><td>@Model.OMAddress1.City</td><td>PO Line Reference Number</td><td></td></tr>
                                <tr><td>Ship to State</td><td>@Model.OMAddress1.State.VechCode</td><td>Product Serial Number</td><td></td></tr>
                                <tr><td>Ship to PINCode</td><td>@Model.OMAddress1.PinCode</td><td>Attribute Details</td><td></td></tr>
                                <tr><td>Receiver EmailID</td><td></td><td>Attribute Value</td><td></td></tr>
                                <tr><td>Receiver PhoneNumber</td><td></td><td>EWBSubSupply Type</td><td>@Model.EWB_SUBTYPE</td></tr>
                                <tr><td>ECommerce GSTIN</td><td></td><td>EWB SubSupply Type Description</td><td></td></tr>
                                <tr><td>Payee Name</td><td></td><td>EWB Transaction Type</td><td>@Model.EWB_TRN_TYPE</td></tr>
                                <tr><td>Payment Mode</td><td></td><td>Transport Mode</td><td>@Model.TrnMode</td></tr>
                                <tr><td>Bank Account Number</td><td></td><td>Type of Cargo</td><td>@Model.TYPE_OF_CARGO</td></tr>
                                <tr><td>Bank IFSC code</td><td></td><td>Distance level(km)</td><td>@Model.DISTANCE_LEVEL</td></tr>
                                <tr>
                                    <td>Payment Terms</td>
                                    <td></td>
                                    <td>Transporter Name</td>
                                    <td>
                                        @if (Model.TransporterID != null)
                                        {
                                            @Model.OMAddress3.PartyName
                                        }
                                    </td>
                                </tr>
                                <tr>
                                    <td>Payment Instructions</td>
                                    <td></td>
                                    <td>Transporter ID</td>
                                    <td>
                                        @if (Model.TransporterID != null)
                                        {
                                            @Model.OMAddress3.GSTCode
                                        }
                                    </td>
                                </tr>
                                <tr><td>Credit Transfer Terms</td><td></td><td>Transport Document No</td><td>@Model.LRNO</td></tr>
                                <tr><td>Direct Debit Terms</td><td></td><td>Transport Document Date</td><td></td></tr>
                                <tr><td>Credit Days</td><td></td><td>Transportere-mail</td><td>@Model.VechNo</td></tr>
                                <tr><td>Amount Paid</td><td></td><td>Vehicle No</td><td></td></tr>
                                <tr><td>Amount Due</td><td></td><td>Entity-1</td><td></td></tr>
                                <tr><td>Due Date</td><td></td><td>Entity-2</td><td></td></tr>
                                <tr><td>Shipping Bill Number</td><td></td><td>Entity-3</td><td></td></tr>
                                <tr><td>Shipping Bill Date</td><td></td><td>Entity-4</td><td></td></tr>
                                <tr><td>Export Duty Amount</td><td></td><td>Invoice Remarks</td><td></td></tr>
                                <tr><td>Port Code</td><td></td><td>Validate INV</td><td></td></tr>
                                <tr><td>Tax Scheme</td><td></td><td>Generate Proforma</td><td></td></tr>
                                <tr><td>Invoice Currency Code</td><td></td><td>Auto Generate Invoice No</td><td></td></tr>
                                <tr><td>Invoice Period Start Date</td><td>01-04-2022</td><td>Auto Generate IRN</td><td>@Model.AutoGenIRN</td></tr>
                                <tr><td>Invoice Period End Date</td><td>31-03-2023</td><td>Auto Generate EWB</td><td>@Model.AutoGenEWB</td></tr>
                                <tr><td>Preceding Invoice Number</td><td></td></tr>
                                <tr><td>Preceding Invoice Date</td><td></td></tr>
                                <tr><td>Other Reference Number</td><td></td></tr>
                                <tr><td>Receipt Advice Number</td><td></td></tr>
                                <tr><td>Receipt Advice Date</td><td></td></tr>
                                <tr><td>Lot/Batch Reference Number</td><td></td></tr>
                                <tr><td>Contract Reference Number</td><td></td></tr>

                            </table>
                            <table style="font-size:14px;" class="table table-bordered table-sm table-dark text-light">
                                <tr>
                                    <td>ID</td>
                                    <td>UOM</td>
                                    <td>HSN</td>
                                    <td>HSNDES</td>
                                    <td>GOODSSERVICES</td>
                                    <td>SUPPLYCAT</td>
                                    <td>Rate</td>
                                    <td>QTYUOM</td>
                                    <td>QTYValue</td>
                                    <td>GST%</td>
                                    <td>IGSTAmt</td>
                                    <td>SGSTAmt</td>
                                    <td>CGSTAmt</td>
                                </tr>
                                @foreach (var exceldata in Model.InvItems)
                                {
                                    <tr>
                                        <td>@exceldata.InvItemID</td>
                                        <td>@exceldata.UOM</td>
                                        <td>@exceldata.HSN</td>
                                        <td>@exceldata.HSNDES</td>
                                        <td>@exceldata.GOODSSERVICES</td>
                                        <td>@exceldata.SUPPLYCAT</td>
                                        <td>@exceldata.Rate</td>
                                        <td>@exceldata.QTYUOM</td>
                                        <td>@exceldata.QTYValue</td>
                                        <td>@Convert.ToDecimal(exceldata.CGSTRate.Value + exceldata.SGSTRate.Value + exceldata.IGSTRate)</td>
                                        <td>@exceldata.IGSTAmt</td>
                                        <td>@exceldata.SGSTAmt</td>
                                        <td>@exceldata.CGSTAmt</td>

                                    </tr>
                                }
                            </table>
                        </div>

                    </div>

                    <table style="display:normal" id="myTable">
                        <tr>
                            <td>Transaction Reference Number</td>
                            <td>Supply Type</td>
                            <td>Invoice Reference Number</td>
                            <td>Invoice Type</td>
                            <td>Invoice Number</td>
                            <td>Invoice Date</td>
                            <td>Invoice Value</td>
                            <td>Department Name</td>
                            <td>Department ID</td>
                            <td>PO Number</td>
                            <td>Transaction Type</td>
                            <td>Transaction Subtype</td>
                            <td>Place of Supply</td>
                            <td>Origin Country</td>
                            <td>Org Code</td>
                            <td>Supplier Code</td>
                            <td>Supplier Location Code</td>
                            <td>Supplier GSTIN/UIN</td>
                            <td>Buyer Code</td>
                            <td class="barcode">Buyer  Location Code </td>  @*Want two space between Buyer and Location word*@
                            <td>Buyer GSTIN/UIN</td>
                            <td>Supplier PAN</td>
                            <td>Reverse Charge</td>
                            <td>Supplier Legal Name</td>
                            <td>Supplier Trade Name</td>
                            <td>Supplier Address 1</td>
                            <td>Supplier Address 2</td>
                            <td>Supplier City</td>
                            <td>Supplier State</td>
                            <td>Supplier PIN Code</td>
                            <td>Supplier E mail ID</td>
                            <td>Supplier Phone Number</td>
                            <td>Buyer Trade Name</td>
                            <td>Buyer Legal Name</td>
                            <td>Buyer Address 1</td>
                            <td>Buyer Address 2</td>
                            <td>Buyer City</td>
                            <td>Buyer State</td>
                            <td>Buyer PIN Code</td>
                            <td>Buyer E mail ID</td>
                            <td>Buyer Phone Number</td>
                            <td>Dispatch Code</td>
                            <td>Dispatch GSTIN</td>
                            <td>Dispatch Name</td>
                            <td>Dispatch Address 1</td>
                            <td>Dispatch Address 2</td>
                            <td>Dispatch City</td>
                            <td>Dispatch State</td>
                            <td>Dispatch PIN Code</td>
                            <td>Dispatcher E mail ID</td>
                            <td>Dispatcher Phone Number</td>
                            <td>Ship Code</td>
                            <td>Ship to Legal Name</td>
                            <td>Ship to Trade Name</td>
                            <td>Ship to GSTIN</td>
                            <td>Ship to Address 1</td>
                            <td>Ship to Address 2</td>
                            <td>Ship to City</td>
                            <td>Ship to State</td>
                            <td>Ship to PIN Code</td>
                            <td>Receiver E mail ID</td>
                            <td>Receiver Phone Number</td>
                            <td>E Commerce GSTIN</td>
                            <td>Payee Name</td>
                            <td>Payment Mode</td>
                            <td>Bank Account Number</td>
                            <td>Bank IFSC code</td>
                            <td>Payment Terms</td>
                            <td>Payment Instructions</td>
                            <td>Credit Transfer Terms</td>
                            <td>Direct Debit Terms</td>
                            <td>Credit Days</td>
                            <td>Amount Paid</td>
                            <td>Amount Due</td>
                            <td>Due Date</td>
                            <td>Shipping Bill Number</td>
                            <td>Shipping Bill Date</td>
                            <td>Export Duty Amount</td>
                            <td>Port Code</td>
                            <td>Tax Scheme</td>
                            <td>Invoice Currency Code</td>
                            <td>Invoice Period Start Date</td>
                            <td>Invoice Period End Date</td>
                            <td>Preceding Invoice Number</td>
                            <td>Preceding Invoice Date</td>
                            <td>Other Reference Number</td>
                            <td>Receipt Advice Number</td>
                            <td>Receipt Advice Date</td>
                            <td>Lot/Batch Reference Number</td>
                            <td>Contract Reference Number</td>
                            <td>External Reference Number</td>
                            <td>Project Reference Number</td>
                            <td>PO Date</td>
                            <td>Supporting Document URL</td>
                            <td>Other Supporting Document</td>
                            <td>Any Other Additional Information</td>
                            <td>Total Invoice Value in Foreign Currency</td>
                            <td>Option for Supplier for Refund</td>
                            <td>Foreign Currency</td>
                            <td>Customer Country Code</td>
                            <td>Total Taxable Value</td>
                            <td>Total IGST Amount</td>
                            <td>Total CGST Amount</td>
                            <td>Total SGST/UTGST Amount</td>
                            <td>Total Cess Amount</td>
                            <td>Total State Cess Amount</td>
                            <td>Rounding Off Amount</td>
                            <td>Discount at Invoice level</td>
                            <td>Charges at Invoice level</td>
                            <td>Flag for Supply covered under sec 7 of IGST Act</td>
                            <td>Original Invoice Value</td>
                            <td>Original POS</td>
                            <td>Original Transaction Type</td>
                            <td>Original Transaction ID</td>
                            <td>Differential Percentage</td>
                            <td>Supply Category</td>
                            <td>Line item ID</td>
                            <td>Goods/Services</td>
                            <td>HSN Code</td>
                            <td>Schedule Description Code</td>
                            <td>HSN Description</td>
                            <td>Exemption Notification No</td>
                            <td>Compensation Cess Description Code</td>
                            <td>RCM Description Code</td>
                            <td>Bar code of Product</td>
                            <td>Quantity</td>
                            <td>Free Quantity</td>
                            <td>UQC</td>
                            <td>Rate per Quantity</td>
                            <td>Gross Value</td>
                            <td>Discount Before GST</td>
                            <td>Pre Taxable Value</td>
                            <td>Taxable Value</td>
                            <td>Batch Name</td>
                            <td>Warranty Date</td>
                            <td>Expiry Date</td>
                            <td>GST Rate</td>
                            <td>Cess Rate</td>
                            <td>State Cess Rate</td>
                            <td>Cess Non Advol Value</td>
                            <td>IGST Amount</td>
                            <td>CGST Amount</td>
                            <td>SGST/ UTGST Amount</td>
                            <td>Compensation Cess Amount</td>
                            <td>State Cess Amount</td>
                            <td>State Cess Non Advol Amount</td>
                            <td>Other Charges</td>
                            <td>PO Line Reference Number</td>
                            <td>Product Serial Number</td>
                            <td>Attribute Details</td>
                            <td>Attribute Value</td>
                            <td>EWB Sub Supply Type</td>
                            <td>EWB Sub Supply Type Description</td>
                            <td>EWB Transaction Type</td>
                            <td>Transport Mode</td>
                            <td>Type of Cargo</td>
                            <td>Distance level(km)</td>
                            <td>Transporter Name</td>
                            <td>Transporter ID</td>
                            <td>Transport Document No</td>
                            <td>Transport<span></span> Date</td> @*Want two space between Transaction and Date word*@
                            <td>Transporter e-mail</td>
                            <td>Vehicle No</td>
                            <td>Entity-1</td>
                            <td>Entity-2</td>
                            <td>Entity-3</td>
                            <td>Entity-4</td>
                            <td>Invoice Remarks</td>
                            <td>Validate INV</td>
                            <td>Generate Proforma</td>
                            <td>Auto Generate Invoice No</td>
                            <td>Auto Generate IRN</td>
                            <td>Auto Generate EWB</td>
                        </tr>
                        @foreach (var exceldata in Model.InvItems)
                        {
                            <tr>
                                <td>@exceldata.InvID</td>
                                <td>@exceldata.InvHead.SupplyType</td>
                                <td></td>
                                <td>@exceldata.InvHead.InvoiceType</td>
                                <td>@exceldata.InvHead.InvRefID</td>
                                <td>@Convert.ToString(exceldata.InvHead.InvDate.Value.ToString("dd-MM-yyyy"))</td>
                                <td>@exceldata.InvHead.GrandAmt</td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td>@exceldata.InvHead.TRNType</td>
                                <td>@exceldata.InvHead.TRNSubType</td>
                                <td>@exceldata.InvHead.OMAddress.State.VechCode</td>
                                <td></td>
                                <td>@exceldata.InvHead.OMAddress2.GSTCode</td>
                                <td></td>
                                <td></td>
                                <td>@exceldata.InvHead.OMAddress2.GSTCode</td>
                                <td></td>
                                <td></td>
                                <td>@exceldata.InvHead.OMAddress.GSTCode</td>
                                <td></td>
                                <td>@exceldata.InvHead.ReverseCharge</td>
                                <td>@exceldata.InvHead.OMAddress2.PartyName</td>
                                <td>LALIT PIPES</td>
                                <td>SURVEY NO. 77, VILLAGE VARASKOL, KHARDI RLY. STN. (CR)</td>
                                <td>TALUKA SHAHPUR, DIST THANE, 421601</td>
                                <td>SHAHAPUR</td>
                                <td>MH</td>
                                <td>421601</td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td>@exceldata.InvHead.OMAddress.PartyName</td>
                                <td>@exceldata.InvHead.OMAddress.Address2</td>
                                <td>@exceldata.InvHead.OMAddress.Address3</td>
                                <td>@exceldata.InvHead.OMAddress.City</td>
                                <td>@exceldata.InvHead.OMAddress.State.VechCode</td>
                                <td>@exceldata.InvHead.OMAddress.PinCode</td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td>@exceldata.InvHead.OMAddress2.GSTCode</td>
                                <td>@exceldata.InvHead.OMAddress2.PartyName</td>
                                <td>@exceldata.InvHead.OMAddress2.Address2</td>
                                <td>@exceldata.InvHead.OMAddress2.Address3</td>
                                <td>@exceldata.InvHead.OMAddress2.City</td>
                                <td>@exceldata.InvHead.OMAddress2.State.VechCode</td>
                                <td>@exceldata.InvHead.OMAddress2.PinCode</td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td>@exceldata.InvHead.OMAddress1.PartyName</td>
                                <td></td>
                                <td>@exceldata.InvHead.OMAddress1.GSTCode</td>
                                <td>@exceldata.InvHead.OMAddress1.Address2</td>
                                <td>@exceldata.InvHead.OMAddress1.Address3</td>
                                <td>@exceldata.InvHead.OMAddress1.City</td>
                                <td>@exceldata.InvHead.OMAddress1.State.VechCode</td>
                                <td>@exceldata.InvHead.OMAddress1.PinCode</td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td>01-04-2023</td>
                                <td>31-03-2024</td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td>@exceldata.InvHead.TaxableAmt</td>
                                <td>@exceldata.InvHead.ItemIGSTAmt</td>
                                <td>@exceldata.InvHead.ItemCGSTAmt</td>
                                <td>@exceldata.InvHead.ItemSGSTAmt</td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td>@Convert.ToDecimal(exceldata.InvHead.OtherTaxAmt + exceldata.InvHead.TCSAmt)</td>
                                <td></td>
                                <td>@exceldata.InvHead.GrandAmt</td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td>@exceldata.SUPPLYCAT</td>
                                <td>@exceldata.InvItemID</td>
                                <td>@exceldata.GOODSSERVICES</td>
                                <td>@exceldata.HSN</td>
                                <td></td>
                                <td>@exceldata.HSNDES</td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td>@exceldata.QTYUOM</td>
                                <td></td>
                                <td>@exceldata.UOM</td>
                                <td>@exceldata.Rate</td>
                                <td>@exceldata.QTYValue</td>
                                <td></td>
                                <td></td>
                                <td>@exceldata.QTYValue</td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td>@Convert.ToDecimal(exceldata.CGSTRate.Value + exceldata.SGSTRate.Value + exceldata.IGSTRate)</td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td>@exceldata.IGSTAmt</td>
                                <td>@exceldata.CGSTAmt</td>
                                <td>@exceldata.SGSTAmt</td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td>@exceldata.InvHead.EWB_SUBTYPE</td>
                                <td></td>
                                <td>@exceldata.InvHead.EWB_TRN_TYPE</td>
                                <td>@exceldata.InvHead.TrnMode</td>
                                <td>@exceldata.InvHead.TYPE_OF_CARGO</td>
                                <td>@exceldata.InvHead.DISTANCE_LEVEL</td>
                                <td>
                                    @if (Model.TransporterID != null)
                                    {
                                        @exceldata.InvHead.OMAddress3.PartyName
                                    }
                                </td>
                                <td>
                                    @if (Model.TransporterID != null)
                                    {
                                        @exceldata.InvHead.OMAddress3.GSTCode
                                    }
                                </td>
                                <td>@exceldata.InvHead.LRNO</td>
                                <td>
                                    @if (exceldata.InvHead.LRDate == null)
                                    {
                                    }
                                    else
                                    {
                                        @Convert.ToString(exceldata.InvHead.LRDate.Value.ToString("dd-MM-yyyy"))
                                    }
                                </td>
                                <td></td>
                                <td>@exceldata.InvHead.VechNo</td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td>@exceldata.InvHead.AutoGenIRN</td>
                                <td>@exceldata.InvHead.AutoGenEWB</td>
                            </tr>
                        }
                    </table>

                </div>
                <div align="center" class="card-footer">

                    <button title="List View" data-toggle="tooltip" class="button button3" onclick="location.href='@Url.Action("IndexInvoice", "Invoice" )';return false;">
                        <span class="fa fa-list"></span>
                    </button>
                </div>
            </div>
        </div>
    </div>
        <script>
            $(document).ready(function () {
                $('#exportBtn').click(function () {
                    var table = document.getElementById('myTable');
                    var wb = XLSX.utils.table_to_book(table, { sheet: 'einvoice', cellDates: true, raw: true });
                    /* generate XLSX file and trigger a download */
                    XLSX.writeFile(wb, 'table_export.xlsx');
                });
            });
        </script>
</body>
I am using SheetJS in my MVC project to export HTML table (id="myTable") to Excel File. I am giving two space to some table column heading, But while exporting data I could not get extra space in excel file. How do I get Extra Space please guide and Thanks in advance. Following is my Code ``` @model EasyApp.Models.InvHead @using EasyApp.Models @{ Layout = "~/Views/Shared/_LayoutExcise.cshtml"; } <head> <meta name="viewport" content="width=device-width" /> <title>Export Data</title> <link href="~/Content/bootstrap.min.css" rel="stylesheet" /> <script src="~/DatatableBS/jquery.dataTables.min.js"></script> <script src="~/DatatableBS/dataTables.bootstrap4.min.js"></script> <link href="~/DatatableBS/dataTables.bootstrap4.min.css" rel="stylesheet" /> @*<script src="~/Scripts/ExcelExportSheetJS.js"></script>*@ <script src="https://cdn.sheetjs.com/xlsx-0.20.0/package/dist/xlsx.full.min.js"></script> <style> .barcode{ white-space:pre; } </style> </head> <body> <div class="EasyViewHeader Raleway">Export eInvoice Data</div> <div class="EasyViewDiv"> <div class="EasyViewContainer"> <div class="col-md-12"> <div class="card"> <div class="card-header"> <h5>Invoice No : @Model.InvRefID (SYSID:@Model.InvID)</h5> </div> <div class="card-body"> <div class="form-group"> <button class="btn btn-outline-success" id="exportBtn">Export to Excel</button> <button class="btn btn-outline-danger" onclick="ExportToExcel('xlsx')">Export Data to excel</button> </div> <div> <table style="font-size:14px;" class="table table-bordered table-striped table-sm table-dark text-light"> <tr><td>Transaction Reference Number</td><td>@Model.InvID</td><td>External Reference Number</td><td></td></tr> <tr><td>Supply Type</td><td>@Model.SupplyType</td><td>Project Reference Number</td><td></td></tr> <tr><td>Invoice Reference Number</td><td></td><td>PO Date</td><td></td></tr> <tr><td>Invoice Type</td><td>@Model.InvoiceType</td><td>Supporting Document URL</td><td></td></tr> <tr><td>Invoice Number</td><td>@Model.InvRefID</td><td>Other Supporting Document</td><td></td></tr> <tr><td>Invoice Date</td><td>@Convert.ToString(Model.InvDate.Value.ToString("dd-MM-yyyy"))</td><td>Any Other Additional Information</td><td></td></tr> <tr><td>Invoice Value</td><td>@Model.GrandAmt</td><td>Total Invoice Value in Foreign Currency</td><td></td></tr> <tr><td>Department Name</td><td></td><td>Option for Supplier for Refund</td><td></td></tr> <tr><td>Department ID</td><td></td><td>Foreign Currency</td><td></td></tr> <tr><td>PO Number</td><td></td><td>Customer Country Code</td><td></td></tr> <tr><td>Transaction Type</td><td>@Model.TRNType</td><td>Total Taxable Value</td><td>@Model.TaxableAmt</td></tr> <tr><td>Transaction Subtype</td><td>@Model.TRNSubType</td><td>Total IGST Amount</td><td>@Model.ItemIGSTAmt</td></tr> <tr><td>Place of Supply</td><td>@Model.OMAddress.State.VechCode</td><td>Total CGST Amount</td><td>@Model.ItemCGSTAmt</td></tr> <tr><td>Origin Country</td><td></td><td>Total SGST/UTGST Amount</td><td>@Model.ItemSGSTAmt</td></tr> <tr><td>Org Code</td><td>@Model.OMAddress2.GSTCode</td><td>Total Cess Amount</td><td></td></tr> <tr><td>Supplier Code</td><td></td><td>Total State Cess Amount</td><td></td></tr> <tr><td>Supplier Location Code</td><td></td><td>Rounding Off Amount</td><td></td></tr> <tr><td>Supplier GSTIN/UIN</td><td>@Model.OMAddress2.GSTCode</td><td>Discount at Invoice level</td><td></td></tr> <tr><td>Buyer Code</td><td></td><td>Charges at Invoice level</td><td>@Model.OtherTaxAmt</td></tr> <tr><td>Buyer Location Code</td><td></td><td>Flag for Supply covered under sec7 of IGST Act</td><td></td></tr> <tr><td>Buyer GSTIN/UIN</td><td>@Model.OMAddress.GSTCode</td><td>Original Invoice Value</td><td>@Model.GrandAmt</td></tr> <tr><td>Supplier PAN</td><td></td><td>Original POS</td><td></td></tr> <tr><td>Reverse Charge</td><td>@Model.ReverseCharge</td><td>Original Transaction Type</td><td></td></tr> <tr><td>Supplier Legal Name</td><td>@Model.OMAddress2.PartyName</td><td>Original Transaction ID</td><td></td></tr> <tr><td>Supplier Trade Name</td><td>LALIT PIPES</td><td>Differential Percentage</td><td></td></tr> <tr><td>Supplier Address1</td><td>SURVEY NO. 77, VILLAGE VARASKOL, KHARDI RLY. STN. (CR)</td><td>Supply Category</td><td></td></tr> <tr><td>Supplier Address2</td><td>TALUKA SHAHPUR, DIST THANE, 421601</td><td>Line item ID</td><td></td></tr> <tr><td>Supplier City</td><td>SHAHAPUR</td><td>Goods/Services</td><td></td></tr> <tr><td>Supplier State</td><td>MH</td><td>HSN Code</td><td></td></tr> <tr><td>Supplier PINCode</td><td>421601</td><td>Schedule Description Code</td><td></td></tr> <tr><td>Supplier EmailID</td><td></td><td>HSN Description</td><td></td></tr> <tr><td>Supplier Phone Number</td><td></td><td>Exemption Notification No</td><td></td></tr> <tr><td>Buyer Trade Name</td><td></td><td>Compensation Cess Description Code</td><td></td></tr> <tr><td>Buyer Legal Name</td><td>@Model.OMAddress.PartyName</td><td>RCM Description Code</td><td></td></tr> <tr><td>Buyer Address1</td><td>@Model.OMAddress.Address2</td><td>Bar code of Product</td><td></td></tr> <tr><td>Buyer Address2</td><td>@Model.OMAddress.Address3</td><td>Quantity</td><td></td></tr> <tr><td>Buyer City</td><td>@Model.OMAddress.City</td><td>Free Quantity</td><td></td></tr> <tr><td>Buyer State</td><td>@Model.OMAddress.State.VechCode</td><td>UQC</td></tr> <tr><td>Buyer PIN Code</td><td>@Model.OMAddress.PinCode</td><td>Rate per Quantity</td><td></td></tr> <tr><td>Buyer EmailID</td><td></td><td>GrossValue</td><td></td></tr> <tr><td>Buyer Phone Number</td><td></td><td>Discount Before GST</td><td></td></tr> <tr><td>Dispatch Code</td><td></td><td>Pre Taxable Value</td><td></td></tr> <tr><td>Dispatch GSTIN</td><td>@Model.OMAddress2.GSTCode</td><td>Taxable Value</td><td></td></tr> <tr><td>Dispatch Name</td><td>@Model.OMAddress2.PartyName</td><td>Batch Name</td><td></td></tr> <tr><td>Dispatch Address1</td><td>@Model.OMAddress2.Address2</td><td>Warranty Date</td><td></td></tr> <tr><td>Dispatch Address2</td><td>@Model.OMAddress2.Address3</td><td>Expiry Date</td><td></td></tr> <tr><td>Dispatch City</td><td>@Model.OMAddress2.City</td><td>GSTRate</td><td></td></tr> <tr><td>Dispatch State</td><td>@Model.OMAddress2.State.VechCode</td><td>Cess Rate</td><td></td></tr> <tr><td>Dispatch PIN Code</td><td>@Model.OMAddress2.PinCode</td><td>State Cess Rate</td><td></td></tr> <tr><td>Dispatcher EmailID</td><td></td><td>Cess Non Advol Value</td><td></td></tr> <tr><td>Dispatcher Phone Number</td><td></td><td>IGST Amount</td><td></td></tr> <tr><td>Ship Code</td><td></td><td>CGST Amount</td><td></td></tr> <tr><td>Ship to Legal Name</td><td>@Model.OMAddress1.PartyName</td><td>SGST/UTGST Amount</td><td></td></tr> <tr><td>Ship to Trade Name</td><td></td><td>Compensation Cess Amount</td><td></td></tr> <tr><td>Ship to GSTIN</td><td>@Model.OMAddress1.GSTCode</td><td>State Cess Amount</td><td></td></tr> <tr><td>Ship to Address1</td><td>@Model.OMAddress1.Address2</td><td>State Cess Non Advol Amount</td><td></td></tr> <tr><td>Ship to Address2</td><td>@Model.OMAddress1.Address3</td><td>Other Charges</td><td></td></tr> <tr><td>Ship to City</td><td>@Model.OMAddress1.City</td><td>PO Line Reference Number</td><td></td></tr> <tr><td>Ship to State</td><td>@Model.OMAddress1.State.VechCode</td><td>Product Serial Number</td><td></td></tr> <tr><td>Ship to PINCode</td><td>@Model.OMAddress1.PinCode</td><td>Attribute Details</td><td></td></tr> <tr><td>Receiver EmailID</td><td></td><td>Attribute Value</td><td></td></tr> <tr><td>Receiver PhoneNumber</td><td></td><td>EWBSubSupply Type</td><td>@Model.EWB_SUBTYPE</td></tr> <tr><td>ECommerce GSTIN</td><td></td><td>EWB SubSupply Type Description</td><td></td></tr> <tr><td>Payee Name</td><td></td><td>EWB Transaction Type</td><td>@Model.EWB_TRN_TYPE</td></tr> <tr><td>Payment Mode</td><td></td><td>Transport Mode</td><td>@Model.TrnMode</td></tr> <tr><td>Bank Account Number</td><td></td><td>Type of Cargo</td><td>@Model.TYPE_OF_CARGO</td></tr> <tr><td>Bank IFSC code</td><td></td><td>Distance level(km)</td><td>@Model.DISTANCE_LEVEL</td></tr> <tr> <td>Payment Terms</td> <td></td> <td>Transporter Name</td> <td> @if (Model.TransporterID != null) { @Model.OMAddress3.PartyName } </td> </tr> <tr> <td>Payment Instructions</td> <td></td> <td>Transporter ID</td> <td> @if (Model.TransporterID != null) { @Model.OMAddress3.GSTCode } </td> </tr> <tr><td>Credit Transfer Terms</td><td></td><td>Transport Document No</td><td>@Model.LRNO</td></tr> <tr><td>Direct Debit Terms</td><td></td><td>Transport Document Date</td><td></td></tr> <tr><td>Credit Days</td><td></td><td>Transportere-mail</td><td>@Model.VechNo</td></tr> <tr><td>Amount Paid</td><td></td><td>Vehicle No</td><td></td></tr> <tr><td>Amount Due</td><td></td><td>Entity-1</td><td></td></tr> <tr><td>Due Date</td><td></td><td>Entity-2</td><td></td></tr> <tr><td>Shipping Bill Number</td><td></td><td>Entity-3</td><td></td></tr> <tr><td>Shipping Bill Date</td><td></td><td>Entity-4</td><td></td></tr> <tr><td>Export Duty Amount</td><td></td><td>Invoice Remarks</td><td></td></tr> <tr><td>Port Code</td><td></td><td>Validate INV</td><td></td></tr> <tr><td>Tax Scheme</td><td></td><td>Generate Proforma</td><td></td></tr> <tr><td>Invoice Currency Code</td><td></td><td>Auto Generate Invoice No</td><td></td></tr> <tr><td>Invoice Period Start Date</td><td>01-04-2022</td><td>Auto Generate IRN</td><td>@Model.AutoGenIRN</td></tr> <tr><td>Invoice Period End Date</td><td>31-03-2023</td><td>Auto Generate EWB</td><td>@Model.AutoGenEWB</td></tr> <tr><td>Preceding Invoice Number</td><td></td></tr> <tr><td>Preceding Invoice Date</td><td></td></tr> <tr><td>Other Reference Number</td><td></td></tr> <tr><td>Receipt Advice Number</td><td></td></tr> <tr><td>Receipt Advice Date</td><td></td></tr> <tr><td>Lot/Batch Reference Number</td><td></td></tr> <tr><td>Contract Reference Number</td><td></td></tr> </table> <table style="font-size:14px;" class="table table-bordered table-sm table-dark text-light"> <tr> <td>ID</td> <td>UOM</td> <td>HSN</td> <td>HSNDES</td> <td>GOODSSERVICES</td> <td>SUPPLYCAT</td> <td>Rate</td> <td>QTYUOM</td> <td>QTYValue</td> <td>GST%</td> <td>IGSTAmt</td> <td>SGSTAmt</td> <td>CGSTAmt</td> </tr> @foreach (var exceldata in Model.InvItems) { <tr> <td>@exceldata.InvItemID</td> <td>@exceldata.UOM</td> <td>@exceldata.HSN</td> <td>@exceldata.HSNDES</td> <td>@exceldata.GOODSSERVICES</td> <td>@exceldata.SUPPLYCAT</td> <td>@exceldata.Rate</td> <td>@exceldata.QTYUOM</td> <td>@exceldata.QTYValue</td> <td>@Convert.ToDecimal(exceldata.CGSTRate.Value + exceldata.SGSTRate.Value + exceldata.IGSTRate)</td> <td>@exceldata.IGSTAmt</td> <td>@exceldata.SGSTAmt</td> <td>@exceldata.CGSTAmt</td> </tr> } </table> </div> </div> <table style="display:normal" id="myTable"> <tr> <td>Transaction Reference Number</td> <td>Supply Type</td> <td>Invoice Reference Number</td> <td>Invoice Type</td> <td>Invoice Number</td> <td>Invoice Date</td> <td>Invoice Value</td> <td>Department Name</td> <td>Department ID</td> <td>PO Number</td> <td>Transaction Type</td> <td>Transaction Subtype</td> <td>Place of Supply</td> <td>Origin Country</td> <td>Org Code</td> <td>Supplier Code</td> <td>Supplier Location Code</td> <td>Supplier GSTIN/UIN</td> <td>Buyer Code</td> <td class="barcode">Buyer Location Code </td> @*Want two space between Buyer and Location word*@ <td>Buyer GSTIN/UIN</td> <td>Supplier PAN</td> <td>Reverse Charge</td> <td>Supplier Legal Name</td> <td>Supplier Trade Name</td> <td>Supplier Address 1</td> <td>Supplier Address 2</td> <td>Supplier City</td> <td>Supplier State</td> <td>Supplier PIN Code</td> <td>Supplier E mail ID</td> <td>Supplier Phone Number</td> <td>Buyer Trade Name</td> <td>Buyer Legal Name</td> <td>Buyer Address 1</td> <td>Buyer Address 2</td> <td>Buyer City</td> <td>Buyer State</td> <td>Buyer PIN Code</td> <td>Buyer E mail ID</td> <td>Buyer Phone Number</td> <td>Dispatch Code</td> <td>Dispatch GSTIN</td> <td>Dispatch Name</td> <td>Dispatch Address 1</td> <td>Dispatch Address 2</td> <td>Dispatch City</td> <td>Dispatch State</td> <td>Dispatch PIN Code</td> <td>Dispatcher E mail ID</td> <td>Dispatcher Phone Number</td> <td>Ship Code</td> <td>Ship to Legal Name</td> <td>Ship to Trade Name</td> <td>Ship to GSTIN</td> <td>Ship to Address 1</td> <td>Ship to Address 2</td> <td>Ship to City</td> <td>Ship to State</td> <td>Ship to PIN Code</td> <td>Receiver E mail ID</td> <td>Receiver Phone Number</td> <td>E Commerce GSTIN</td> <td>Payee Name</td> <td>Payment Mode</td> <td>Bank Account Number</td> <td>Bank IFSC code</td> <td>Payment Terms</td> <td>Payment Instructions</td> <td>Credit Transfer Terms</td> <td>Direct Debit Terms</td> <td>Credit Days</td> <td>Amount Paid</td> <td>Amount Due</td> <td>Due Date</td> <td>Shipping Bill Number</td> <td>Shipping Bill Date</td> <td>Export Duty Amount</td> <td>Port Code</td> <td>Tax Scheme</td> <td>Invoice Currency Code</td> <td>Invoice Period Start Date</td> <td>Invoice Period End Date</td> <td>Preceding Invoice Number</td> <td>Preceding Invoice Date</td> <td>Other Reference Number</td> <td>Receipt Advice Number</td> <td>Receipt Advice Date</td> <td>Lot/Batch Reference Number</td> <td>Contract Reference Number</td> <td>External Reference Number</td> <td>Project Reference Number</td> <td>PO Date</td> <td>Supporting Document URL</td> <td>Other Supporting Document</td> <td>Any Other Additional Information</td> <td>Total Invoice Value in Foreign Currency</td> <td>Option for Supplier for Refund</td> <td>Foreign Currency</td> <td>Customer Country Code</td> <td>Total Taxable Value</td> <td>Total IGST Amount</td> <td>Total CGST Amount</td> <td>Total SGST/UTGST Amount</td> <td>Total Cess Amount</td> <td>Total State Cess Amount</td> <td>Rounding Off Amount</td> <td>Discount at Invoice level</td> <td>Charges at Invoice level</td> <td>Flag for Supply covered under sec 7 of IGST Act</td> <td>Original Invoice Value</td> <td>Original POS</td> <td>Original Transaction Type</td> <td>Original Transaction ID</td> <td>Differential Percentage</td> <td>Supply Category</td> <td>Line item ID</td> <td>Goods/Services</td> <td>HSN Code</td> <td>Schedule Description Code</td> <td>HSN Description</td> <td>Exemption Notification No</td> <td>Compensation Cess Description Code</td> <td>RCM Description Code</td> <td>Bar code of Product</td> <td>Quantity</td> <td>Free Quantity</td> <td>UQC</td> <td>Rate per Quantity</td> <td>Gross Value</td> <td>Discount Before GST</td> <td>Pre Taxable Value</td> <td>Taxable Value</td> <td>Batch Name</td> <td>Warranty Date</td> <td>Expiry Date</td> <td>GST Rate</td> <td>Cess Rate</td> <td>State Cess Rate</td> <td>Cess Non Advol Value</td> <td>IGST Amount</td> <td>CGST Amount</td> <td>SGST/ UTGST Amount</td> <td>Compensation Cess Amount</td> <td>State Cess Amount</td> <td>State Cess Non Advol Amount</td> <td>Other Charges</td> <td>PO Line Reference Number</td> <td>Product Serial Number</td> <td>Attribute Details</td> <td>Attribute Value</td> <td>EWB Sub Supply Type</td> <td>EWB Sub Supply Type Description</td> <td>EWB Transaction Type</td> <td>Transport Mode</td> <td>Type of Cargo</td> <td>Distance level(km)</td> <td>Transporter Name</td> <td>Transporter ID</td> <td>Transport Document No</td> <td>Transport<span></span> Date</td> @*Want two space between Transaction and Date word*@ <td>Transporter e-mail</td> <td>Vehicle No</td> <td>Entity-1</td> <td>Entity-2</td> <td>Entity-3</td> <td>Entity-4</td> <td>Invoice Remarks</td> <td>Validate INV</td> <td>Generate Proforma</td> <td>Auto Generate Invoice No</td> <td>Auto Generate IRN</td> <td>Auto Generate EWB</td> </tr> @foreach (var exceldata in Model.InvItems) { <tr> <td>@exceldata.InvID</td> <td>@exceldata.InvHead.SupplyType</td> <td></td> <td>@exceldata.InvHead.InvoiceType</td> <td>@exceldata.InvHead.InvRefID</td> <td>@Convert.ToString(exceldata.InvHead.InvDate.Value.ToString("dd-MM-yyyy"))</td> <td>@exceldata.InvHead.GrandAmt</td> <td></td> <td></td> <td></td> <td>@exceldata.InvHead.TRNType</td> <td>@exceldata.InvHead.TRNSubType</td> <td>@exceldata.InvHead.OMAddress.State.VechCode</td> <td></td> <td>@exceldata.InvHead.OMAddress2.GSTCode</td> <td></td> <td></td> <td>@exceldata.InvHead.OMAddress2.GSTCode</td> <td></td> <td></td> <td>@exceldata.InvHead.OMAddress.GSTCode</td> <td></td> <td>@exceldata.InvHead.ReverseCharge</td> <td>@exceldata.InvHead.OMAddress2.PartyName</td> <td>LALIT PIPES</td> <td>SURVEY NO. 77, VILLAGE VARASKOL, KHARDI RLY. STN. (CR)</td> <td>TALUKA SHAHPUR, DIST THANE, 421601</td> <td>SHAHAPUR</td> <td>MH</td> <td>421601</td> <td></td> <td></td> <td></td> <td>@exceldata.InvHead.OMAddress.PartyName</td> <td>@exceldata.InvHead.OMAddress.Address2</td> <td>@exceldata.InvHead.OMAddress.Address3</td> <td>@exceldata.InvHead.OMAddress.City</td> <td>@exceldata.InvHead.OMAddress.State.VechCode</td> <td>@exceldata.InvHead.OMAddress.PinCode</td> <td></td> <td></td> <td></td> <td>@exceldata.InvHead.OMAddress2.GSTCode</td> <td>@exceldata.InvHead.OMAddress2.PartyName</td> <td>@exceldata.InvHead.OMAddress2.Address2</td> <td>@exceldata.InvHead.OMAddress2.Address3</td> <td>@exceldata.InvHead.OMAddress2.City</td> <td>@exceldata.InvHead.OMAddress2.State.VechCode</td> <td>@exceldata.InvHead.OMAddress2.PinCode</td> <td></td> <td></td> <td></td> <td>@exceldata.InvHead.OMAddress1.PartyName</td> <td></td> <td>@exceldata.InvHead.OMAddress1.GSTCode</td> <td>@exceldata.InvHead.OMAddress1.Address2</td> <td>@exceldata.InvHead.OMAddress1.Address3</td> <td>@exceldata.InvHead.OMAddress1.City</td> <td>@exceldata.InvHead.OMAddress1.State.VechCode</td> <td>@exceldata.InvHead.OMAddress1.PinCode</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td>01-04-2023</td> <td>31-03-2024</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td>@exceldata.InvHead.TaxableAmt</td> <td>@exceldata.InvHead.ItemIGSTAmt</td> <td>@exceldata.InvHead.ItemCGSTAmt</td> <td>@exceldata.InvHead.ItemSGSTAmt</td> <td></td> <td></td> <td></td> <td></td> <td>@Convert.ToDecimal(exceldata.InvHead.OtherTaxAmt + exceldata.InvHead.TCSAmt)</td> <td></td> <td>@exceldata.InvHead.GrandAmt</td> <td></td> <td></td> <td></td> <td></td> <td>@exceldata.SUPPLYCAT</td> <td>@exceldata.InvItemID</td> <td>@exceldata.GOODSSERVICES</td> <td>@exceldata.HSN</td> <td></td> <td>@exceldata.HSNDES</td> <td></td> <td></td> <td></td> <td></td> <td>@exceldata.QTYUOM</td> <td></td> <td>@exceldata.UOM</td> <td>@exceldata.Rate</td> <td>@exceldata.QTYValue</td> <td></td> <td></td> <td>@exceldata.QTYValue</td> <td></td> <td></td> <td></td> <td>@Convert.ToDecimal(exceldata.CGSTRate.Value + exceldata.SGSTRate.Value + exceldata.IGSTRate)</td> <td></td> <td></td> <td></td> <td>@exceldata.IGSTAmt</td> <td>@exceldata.CGSTAmt</td> <td>@exceldata.SGSTAmt</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td>@exceldata.InvHead.EWB_SUBTYPE</td> <td></td> <td>@exceldata.InvHead.EWB_TRN_TYPE</td> <td>@exceldata.InvHead.TrnMode</td> <td>@exceldata.InvHead.TYPE_OF_CARGO</td> <td>@exceldata.InvHead.DISTANCE_LEVEL</td> <td> @if (Model.TransporterID != null) { @exceldata.InvHead.OMAddress3.PartyName } </td> <td> @if (Model.TransporterID != null) { @exceldata.InvHead.OMAddress3.GSTCode } </td> <td>@exceldata.InvHead.LRNO</td> <td> @if (exceldata.InvHead.LRDate == null) { } else { @Convert.ToString(exceldata.InvHead.LRDate.Value.ToString("dd-MM-yyyy")) } </td> <td></td> <td>@exceldata.InvHead.VechNo</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td>@exceldata.InvHead.AutoGenIRN</td> <td>@exceldata.InvHead.AutoGenEWB</td> </tr> } </table> </div> <div align="center" class="card-footer"> <button title="List View" data-toggle="tooltip" class="button button3" onclick="location.href='@Url.Action("IndexInvoice", "Invoice" )';return false;"> <span class="fa fa-list"></span> </button> </div> </div> </div> </div> <script> $(document).ready(function () { $('#exportBtn').click(function () { var table = document.getElementById('myTable'); var wb = XLSX.utils.table_to_book(table, { sheet: 'einvoice', cellDates: true, raw: true }); /* generate XLSX file and trigger a download */ XLSX.writeFile(wb, 'table_export.xlsx'); }); }); </script> </body> ```
ExporttoExcel.txt
37 KiB
rajufodse commented 2023-11-28 06:05:03 +00:00
Author
Copy Link

Output of above code in attached Excel File

Output of above code in attached Excel File
99.xlsx
13 KiB
sheetjs commented 2023-12-06 19:41:02 +00:00
Owner
Copy Link

In the future, use 3 backticks to denote code blocks.

Assuming you are talking about

<td class="barcode">Buyer  Location Code </td>  @*Want two space between Buyer and Location word*@

You are describing HTML behavior. HTML will collapse multiple spaces by default.

To force two spaces, there are two options:

A) use explicit &nbsp; (the parser will force a space character)

<td class="barcode">Buyer &nbsp;Location Code </td>

B) use a value override (the parser will ignore the HTML and use the attribute value):

<td class="barcode" data-t="s" data-v="Buyer  Location Code ">Buyer  Location Code </td>
In the future, use 3 backticks to denote code blocks. Assuming you are talking about ```html <td class="barcode">Buyer Location Code </td> @*Want two space between Buyer and Location word*@ ``` You are describing HTML behavior. HTML will collapse multiple spaces by default. To force two spaces, there are two options: A) use explicit `&nbsp;` (the parser will force a space character) ```html <td class="barcode">Buyer &nbsp;Location Code </td> ``` B) use a [value override](https://docs.sheetjs.com/docs/api/utilities/html#value-override) (the parser will ignore the HTML and use the attribute value): ```html <td class="barcode" data-t="s" data-v="Buyer Location Code ">Buyer Location Code </td> ```
rajufodse commented 2023-12-16 07:38:21 +00:00
Author
Copy Link

Million of Thanks for your information

Million of Thanks for your information
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
master
sankhavaramsaitulasiram/feat-fix-2752
maybeswapnil/issue2737
gh-pages
scottysseus/2560_2
ivan-trusov/fix-basedate
nandanv2702/issue_1300
protobi/master
ThomasChan/master
grantfayvor/master
tom-groves/bug-1105/rounding-error
mgreter/master
v0.20.2
v0.20.1
v0.20.0
v0.19.3
v0.19.2
v0.19.1
v0.19.0
v0.18.12
v0.18.11
v0.18.10
v0.18.9
v0.18.8
v0.18.7
v0.18.5
v0.18.4
v0.18.3
v0.18.2
v0.18.1
v0.18.0
v0.17.5
v0.17.4
v0.17.3
v0.17.2
v0.17.1
v0.17.0
v0.16.8
v0.16.7
v0.16.6
v0.16.5
v0.16.3
v0.16.2
v0.16.1
v0.16.0
v0.15.6
v0.15.5
v0.15.2
v0.14.0
v0.13.5
v0.13.4
v0.13.3
v0.13.1
v0.13.0
v0.12.13
v0.12.12
v0.12.11
v0.12.10
v0.12.9
v0.12.8
v0.12.7
v0.12.6
v0.12.5
v0.12.4
v0.12.3
v0.12.2
v0.12.1
v0.12.0
v0.11.19
v0.11.18
v0.11.17
v0.11.16
v0.11.15
v0.11.14
v0.11.13
v0.11.12
v0.11.11
v0.11.10
v0.11.9
v0.11.8
v0.11.7
v0.11.6
v0.11.5
v0.11.4
v0.11.3
v0.11.2
v0.11.1
v0.11.0
v0.10.9
v0.10.8
v0.10.7
v0.10.6
v0.10.5
v0.10.4
v0.10.3
v0.10.2
v0.10.1
v0.10.0
v0.9.13
v0.9.12
v0.9.11
v0.9.10
v0.9.9
v0.9.8
v0.9.7
v0.9.6
v0.9.5
v0.9.4
v0.9.3
v0.9.2
v0.9.1
v0.9.0
v0.8.8
v0.8.7
v0.8.6
v0.8.5
v0.8.4
v0.8.3
v0.8.2
v0.8.1
v0.8.0
v0.7.11
v0.7.10
v0.7.9
v0.7.7
v0.7.6-i
v0.7.6-h
v0.7.6-a
v0.7.6
v0.7.5
v0.7.4
v0.7.3
v0.7.2
v0.7.1
v0.5.10
v0.5.9
v0.5.8
v0.5.7
v0.5.0
v0.4.3
Labels
Clear labels   
DBF

   
Dates

   
Defined Names

   
Features

   
Formula

   
HTML

   
Images

   
Infrastructure

   
Integration

   
International

   
ODS

   
Operations

   
Performance

   
PivotTables

   
Pro

   
Protection

   
Read Bug

   
SSF

   
SYLK

   
Style

   
Write Bug

   
good first issue
No Label
DBF
Dates
Defined Names
Features
Formula
HTML
Images
Infrastructure
Integration
International
ODS
Operations
Performance
PivotTables
Pro
Protection
Read Bug
SSF
SYLK
Style
Write Bug
good first issue
Milestone
Clear milestone
No items
No Milestone
Assignees
Clear assignees
No Assignees
2 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: sheetjs/sheetjs#3037
No description provided.
Delete Branch "%!s(<nil>)"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?