search

dfinke / ImportExcel

PowerShell module to import/export Excel spreadsheets, without Excel
https://www.powershellgallery.com/packages/ImportExcel/
Apache License 2.0
2.47k stars 400 forks source link

SharePoint files #1193

Closed esbranson closed 2 years ago

esbranson commented 2 years ago

It would be useful to be able to open SharePoint and other files served over HTTP.

dfinke commented 2 years ago

Yes. I believe the target endpoint needs to serve the xlsx. For example, GitHub doesn't, or it does, and I have not figured out how. The xlsx is a zip, and the libraries the crack it open need to do so it can process the xml.

If that can be figured out with the constraints of EPPlus. Happy to implement.

I have a Read-Csv function that knows how to read a string, file, or url https://github.com/dfinke/PSKit/blob/master/ReadCsv.ps1

Would love to add that to this module.