rainabba
Add XLSX export with border support via OpenXML
The plugin now supports exporting to proper XLSX format with cell borders using the OpenXML specification.
Implementation
-
OpenXML XLSX generation: Implements full XLSX file structure via JSZip
-
[Content_Types].xml,_rels/.rels,xl/workbook.xml,xl/styles.xml,xl/worksheets/sheet1.xml - Border styles defined in
xl/styles.xmlwith thin black borders on all sides - Cells reference border style via
s="1"attribute
-
-
New options:
-
borders(boolean, default: false) - Enables XLSX export with borders -
excelFormat(string, default: "xls") - Choose "xls" or "xlsx" format
-
-
Security: Sheet names and cell values properly XML-escaped to prevent injection
-
Dependencies: Added JSZip to
package.jsonandbower.json
Usage
// Enable borders (automatically switches to XLSX)
$("#table").table2excel({
filename: "export.xlsx",
borders: true
});
// Explicit XLSX format
$("#table").table2excel({
excelFormat: "xlsx",
borders: true
});
Note: Requires JSZip library on the page. If not present, displays error message instead of attempting fallback.
Demo
Updated demo includes local jQuery/JSZip libraries and showcases border functionality:
Backward Compatibility
Default behavior unchanged - XLS format without borders remains the default. All existing options continue to work.
[!WARNING]
Firewall rules blocked me from connecting to one or more addresses (expand for details)
I tried to connect to the following addresses, but was blocked by firewall rules:
ajax.googleapis.com
- Triggering command:
/usr/bin/curl curl -o jquery.min.js REDACTED(dns block)If you need me to access, download, or install something from one of these locations, you can either:
- Configure Actions setup steps to set up my environment, which run before the firewall is enabled
- Add the appropriate URLs or hosts to the custom allowlist in this repository's Copilot coding agent settings (admins only)
Original prompt
This section details on the original issue you should resolve
<issue_title>can this plugin export excel with "border"?</issue_title>
<issue_description>
</issue_description>
<agent_instructions># OpenXML Excel Generation Specification (Borders & Styles)
This specification outlines how to construct a valid .xlsx file from scratch. An Excel file is a ZIP archive of specific XML files. To apply borders, you must define them in a central style gallery and reference them by index in the sheet data.
1. Required File Structure
The ZIP archive must contain the following hierarchy:
/
├── [Content_Types].xml
├── _rels/
│ └── .rels
├── xl/
│ ├── workbook.xml
│ ├── styles.xml
│ ├── _rels/
│ │ └── workbook.xml.rels
│ └── worksheets/
│ └── sheet1.xml
2. Core XML Boilerplate
Root Relationship: _rels/.rels
Tells Excel where the main workbook file is located.
<?xml version="1.0" encoding="UTF-8"?>
<Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships">
<Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument" Target="xl/workbook.xml"/>
</Relationships>
Workbook Definition: xl/workbook.xml
Defines the sheets within the workbook.
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<workbook xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships">
<sheets>
<sheet name="Sheet1" sheetId="1" r:id="rId1"/>
</sheets>
</workbook>
Workbook Relationships: xl/_rels/workbook.xml.rels
Links the workbook to the sheet data and the style definitions.
<?xml version="1.0" encoding="UTF-8"?>
<Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships">
<Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet" Target="worksheets/sheet1.xml"/>
<Relationship Id="rId2" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/styles" Target="styles.xml"/>
</Relationships>
3. Style Implementation (xl/styles.xml)
To add borders, you must follow the strict order of children in the <styleSheet>: Fonts > Fills > Borders > CellXfs.
-
Borders Index: The first
<border>(index 0) is the default (empty). Your custom border is index 1. -
CellXfs (Format): This maps a cell style to a border.
borderId="1"refers to the second border entry.
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<styleSheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<fonts count="1"><font><sz val="11"/><name val="Calibri"/></font></fonts>
<fills count="2">
<fill><patternFill patternType="none"/></fill>
<fill><patternFill patternType="gray125"/></fill>
</fills>
<borders count="2">
<border><left/><right/><top/><bottom/></border> <border> <left style="thin"><color rgb="FF000000"/></left>
<right style="thin"><color rgb="FF000000"/></right>
<top style="thin"><color rgb="FF000000"/></top>
<bottom style="thin"><color rgb="FF000000"/></bottom>
</border>
</borders>
<cellXfs count="2">
<xf borderId="0" fillId="0" fontId="0" numFmtId="0"/> <xf borderId="1" fillId="0" fontId="0" numFmtId="0" applyBorder="1"/> </cellXfs>
</styleSheet>
4. Applying Styles in xl/worksheets/sheet1.xml
In the worksheet, use the s attribute to reference the style index defined in cellXfs.
<sheetData>
<row r="1">
<c r="A1" s="1" t="inlineStr">
<is><t>This cell has a border.</t></is>
</c>
<c r="B1" s="0" t="inlineStr">
<is><t>This cell does not.</t></is>
</c>
</row>
</sheetData>
5. Assembly Logic (JavaScript)
const zip = new JSZip();
// Build the structure
zip.file("_rels/.rels", relsXml);
zip.file("[Content_Types].xml", contentTypesXml);
zip.file("xl/workbook.xml", workbookXml);
zip.file("xl/_rels/workbook.xml.rels", workbookRelsXml);
zip.file("xl/styles.xml", stylesXml);
zip.file("xl/worksheets/sheet1.xml", sheetXml);
// Export
zip.generateAsync({ type: "blob" }).then(blob => {
const url = window.URL.createObjectURL(blob);
const a = document.createElement("a");
a.href = url;
a.download = "StyledExport.xlsx";
a.click();
});
```</agent_instructions>
## Comments on the Issue (you are @copilot in this section)
<comments>
<comment_new><author>@rainabba</author><body>
Here is a spec for an agent to enhance this project by adding border support to the output file.
# OpenXML Excel Generation Specification (Borders & Styles)
This specification outlines how to construct a valid `.xlsx` file from scratch. An Excel file is a ZIP archive of specific XML files. To apply borders, you must define them in...
</details>
<!-- START COPILOT CODING AGENT SUFFIX -->
- Fixes rainabba/jquery-table2excel#136
<!-- START COPILOT CODING AGENT TIPS -->
---
💬 We'd love your input! Share your thoughts on Copilot coding agent in our [2 minute survey](https://gh.io/copilot-coding-agent-survey).
@copilot The examples show cells with "This shouldn't get exported" and "This shouldn't get exported either" so the intended exclusion logic is broken. Please address this.
