Comments (2)
version 4.0.13
I noticed that line 447 of Export-Excel.ps1 also has 'm/d/yy h:mm'
rather than the suggested fix by jhoneill to make it culture dependant
also its in Set-Rows line 115 and Set-columns line 111 as well
from importexcel.
Hi @Penkethboy
I went through the file and added some comments for this because there are some special cases where the underlying library recognises the format written in US style and stores it (in this case) as "format 14" which is "Short date". 'm/d/yy h:mm' is captured, but 'm/d/yy' isn't 'mm/dd/yy h:mm' isn't either. If the
The way I proposed originally would be great until I shared my file with someone who had a different culture set - then they would get a sheet with my local culture hard coded into it.
from importexcel.
Related Issues (20)
- Exporting hashtable to new (empty) file doesn't transfer as expected HOT 4
- Exporting with default theme now renders as purple after recent office update? HOT 11
- New-ConditionalText Question HOT 1
- Exporting worksheet to csv while keeping excel formats (where applicable) HOT 9
- Set-ExcelRange -Formula issue HOT 1
- KillExcel fails
- Feature Request: Set the default worksheet when the workbook is opened HOT 3
- Close-ExcelPackage -Show broken on MacOS due to PowerShell issue HOT 1
- Add -Calculate to Open-ExcelPackage and Import-Excel
- Export-Excel -Style work wrong with multiple sheets HOT 4
- Help with getting a Table without Headers HOT 6
- Exception calling "Save" with "0" argument(s) HOT 3
- Faulty Hyperlink to web site using OfficeOpenXml.ExcelHyperLink HOT 2
- Question: How to colorize header columns HOT 3
- Question: How to match a keyword (stored in a variable) in a specific column and color a range? HOT 2
- Formatting OutPut HOT 1
- Created PivotTables that have same SourceWorkSheet and same SourceRange, but manually created slicer cannot see both of them HOT 2
- TableTotalSettings Formulas transformed by Excel HOT 3
- Bug: Spreadsheet with data above StartRow causes column headers to be duplicated HOT 5
- Set-excelrange after export-excel with '-append' results in exception
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 importexcel.