exceldatatables | worksheet within an Excel workbook | Data Visualization library

by svrnm PHP Version: v0.2.2 License: Apache-2.0

X-Ray Key Features Code Snippets Community Discussions(1)Vulnerabilities Install Support

kandi X-RAY | exceldatatables Summary

exceldatatables is a PHP library typically used in Analytics, Data Visualization applications. exceldatatables has no bugs, it has no vulnerabilities, it has a Permissive License and it has low support. You can download it from GitHub.

Replace a worksheet within an Excel workbook (.xlsx) without changing any other properties of the file.

Support

Quality

Security

License

Reuse

Support

exceldatatables has a low active ecosystem.

It has 25 star(s) with 17 fork(s). There are 4 watchers for this library.

It had no major release in the last 12 months.

There are 1 open issues and 9 have been closed. On average issues are closed in 268 days. There are no pull requests.

It has a neutral sentiment in the developer community.

The latest version of exceldatatables is v0.2.2

Quality

exceldatatables has no bugs reported.

Security

exceldatatables has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

License

exceldatatables is licensed under the Apache-2.0 License. This license is Permissive.

Permissive licenses have the least restrictions, and you can use them in most projects.

Reuse

exceldatatables releases are available to install and integrate.

Installation instructions, examples and code snippets are available.

Top functions reviewed by kandi - BETA

kandi has reviewed exceldatatables and discovered the below as its top functions. This is intended to give you an instant insight into exceldatatables implemented functionality, and help decide if they suit your requirements.

Get date time format id
Append a worksheet
Convert a DateTime object to a DateTime object
Attach data to a file .
Add a row to the table
It takes an existing worksheet
Convert a column to XML
Wraps a worksheet
It converts data to XML
It accepts multidimensional array

Get all kandi verified functions for this library.

exceldatatables Key Features

No Key Features are available at this moment for exceldatatables.

exceldatatables Examples and Code Snippets

No Code Snippets are available at this moment for exceldatatables.

Community Discussions

Trending Discussions on exceldatatables

use "exceldatatables" to join two sheets of a different workbook

QUESTION

use "exceldatatables" to join two sheets of a different workbook

Asked 2017-Nov-06 at 12:06

I have to create an Excel file with a data sheet that will vary according to a database and a sheet containing multiple PivotTables that have their own PivotCharts.

"data.xlsx" contains a sheet with all new data.

"graph.xlsx" contains a sheet with old data and a sheet with PivotTables.

My goal is to have "graph.xlsx" containing a sheet with all new data and the sheet with PivotTables.

I found a perfect lib to do this : https://github.com/svrnm/exceldatatables

But I block on the use of it, I would open "graph.xlsx" delete its sheet named "brut data", then to add a new sheet named "brut data" initialized with the new data contained in "data.xlsx".

To do it I saw this function from ExcelWorkbook.php a Class of this lib.

...

ANSWER

Answered 2017-Nov-06 at 12:06

(I'm the author of the mentioned library)

There are two steps you need to take, to achieve your goal, the first is reading the data.xlsx. The second is writing that data into your graph.xlsx. The library is solving step two:

Source https://stackoverflow.com/questions/46709803

Community Discussions, Code Snippets contain sources that include Stack Exchange Network