Comments (5)
Hyperlink formatting isn't covered (yet).
For quick I created a cell with a hyperlink to a workbook, unzipped (jar -xfv ex1.xlsx
) and opened up in WebStorm to see what this might entail.
The file /xl/styles.xml
defines an <xf>
element that references a <cellStyle>
element defined in a section <cellStyles>
that defines a few other built in styles around the idea of hyperlinks.
So it seems that hyperlinks are actually styles, and it should be technically possible to add. But for right now that's not in.
<cellXfs>
...
<xf numFmtId="0" fontId="1" fillId="0" borderId="0" xfId="7"/>
</cellXfs>
<cellStyles count="8">
<cellStyle name="Followed Hyperlink" xfId="2" builtinId="9" hidden="1"/>
<cellStyle name="Followed Hyperlink" xfId="4" builtinId="9" hidden="1"/>
<cellStyle name="Followed Hyperlink" xfId="6" builtinId="9" hidden="1"/>
<cellStyle name="Hyperlink" xfId="1" builtinId="8" hidden="1"/>
<cellStyle name="Hyperlink" xfId="3" builtinId="8" hidden="1"/>
<cellStyle name="Hyperlink" xfId="5" builtinId="8" hidden="1"/>
<cellStyle name="Hyperlink" xfId="7" builtinId="8"/>
<cellStyle name="Normal" xfId="0" builtinId="0"/>
</cellStyles>
from js-xlsx.
Thanks @protobi for verifying this.
So I added the link using the formula by setting cell data as:
{
v: '=HYPERLINK("http link", "some text")',
t: 's'
}
Is that what you did?
The cell just shows the above string as it is and doesn't execute it.
Are formulae in general not working?
from js-xlsx.
@vinodmehta Hyperlink formatting is not part of js-xlsx yet. My note was more about exploring what it would take to add it. To explore that I created a workbook with a hyperlink using Excel, and then inspected the .pptx file directly in a development environment to see how that hyperlink was represented.
from js-xlsx.
Any update on this Issue? When can we expect it ?
from js-xlsx.
up
from js-xlsx.
Related Issues (20)
- Add comments/note can not export or export very slow, without comments, it will export very quick
- vite上怎么配置config.externals({ "./cptable": "var cptable" }); HOT 8
- add some comment XLSX.write page unresponsive
- Why I installed js-xlsx, there is no json_to_sheet method after import
- Not able to at add comments to the cell while writing it through xlsx-style.
- Depends on vulnerable versions of jszip
- cptable is not defined
- Need to remove unprotected cells containing formula warning icon in excel sheet
- How to set cell wrapping?
- How to parse ‘excel formula' using node js to get the actual value from the excel sheet.
- How use typescript in this project?
- Please lock the commander version, otherwise it cannot support Node v12
- Read styles for HTML table cell
- jszip is not a constructor
- How to set different text styles in cells with xlsx-style , example: C3:{ t : "s" v : "<p>Update Wifi long-term supply <span style=\"text-decoration: underline;\">plan</span> and impact to <strong>production</strong> }
- js.forEach is not a function HOT 1
- RollupError: Could not resolve "../xlsx" from "../xlsx?commonjs-external" HOT 1
- Denial of Service (DoS) affecting package jszip.
- Excel to PDF Page size and scaling issue
- what is this issue i am not able to understand and resolve
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from js-xlsx.