Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

How to specify data type in html using attribute html #3444

Closed
PouriaSeyfi opened this issue Mar 9, 2023 · 2 comments
Closed

How to specify data type in html using attribute html #3444

PouriaSeyfi opened this issue Mar 9, 2023 · 2 comments

Comments

@PouriaSeyfi
Copy link
Contributor

PouriaSeyfi commented Mar 9, 2023 •
edited
Loading

During HTML to Excel conversion, it is sometimes necessary to know what date type should be used :

                <table>
                    <tr>
                        <!-- boolean data type -->
                        <td data-type="b">1</td>
                        <!-- string data type -->
                        <td data-type="s">12345678987654321</td>
                        <!-- formula data type -->
                        <td data-type="f">=CONCAT("TEXT A ","TEXT B")</td>
                    </tr>
                </table>
PouriaSeyfi added a commit to PouriaSeyfi/PhpSpreadsheet that referenced this issue Mar 9, 2023
@PouriaSeyfi
Specify data type in html tags using attributes PHPOffice#3444
8b2d941
@PouriaSeyfi PouriaSeyfi mentioned this issue Mar 9, 2023
Merged
PouriaSeyfi added a commit to PouriaSeyfi/PhpSpreadsheet that referenced this issue Mar 10, 2023
@PouriaSeyfi
Specify data type in html tags using attributes PHPOffice#3444
eac0aef
PouriaSeyfi added a commit to PouriaSeyfi/PhpSpreadsheet that referenced this issue Mar 10, 2023
@PouriaSeyfi
Specify data type in html tags using attributes PHPOffice#3444
6b85c37
@PouriaSeyfi
Copy link
Contributor Author

PouriaSeyfi commented Mar 13, 2023 •
edited
Loading

Please review this PR
@MarkBaker
@oleibman

oleibman pushed a commit that referenced this issue Mar 18, 2023
@PouriaSeyfi
Specify data type in html tags using attributes (#3445)
603d093 
* Specify data type in html tags using attributes #3444

* Set data types using attributes in flushCell function and add some unit tests

* Check TYPE_INLINE in flushCell and some changes in test cases
@oleibman
Copy link
Collaborator

oleibman commented Apr 9, 2023

Resolved by PR #3445.

@oleibman oleibman closed this as completed Apr 9, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@oleibman @PouriaSeyfi