N
N
nwbck2018-02-16 15:50:04
PHP
nwbck, 2018-02-16 15:50:04

Is it possible to output a table with styles from xlsx or google sheets? Are you more interested in xlsx?

It is required to take information from the xlsx table and insert it into html. Problem with saving styles. That is, there will be several labels in the table, which should be highlighted.
It was possible to display the table using phpspreadsheet, but I did not understand the styles. Is it even possible?
If you can not take styles from xlsx, you can try to work with Google spreadsheets

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
Anton Kiselyov, 2018-02-16
@zamboga

look here:
How can I convert Excel to HTML table?

I
Ivan, 2018-02-16
@Iv_and_S

Is it even possible?

Maybe. I don't see any fundamental problem.
A style in an exel/google sheet is a set of characteristics (color, fill, borders, etc.) - you need to parse these characteristics. It's available through the API.
Whether a specific framework or a library out of the box can do this is the question.
https://phpspreadsheet.readthedocs.io/en/develop/t... - here there are some ->getActiveSheet()->getStyle('B2') - what's wrong with them?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question