Comments (9)
Thanks for trying ImportExcel.
so if the the Excel sheet has "$1,234.00" that is what you want in the csv?
from importexcel.
Yep! Or say a (1,000) instead of -1000. Or if we append some text suffix to a value...such as the value is 2 but the custom format text is 2 days.
from importexcel.
Off the top of my head, I don't recall having that. I'll think about if it is in there. Took a quick scan, didn't see anything.
Need to take a deeper look. If it is not there, will think about how hard to add.
from importexcel.
You're awesome! The functionality is to try and replicate if I 'save as' my xlsx worksheet to csv. It prompts me that I'll lose some unsupported stuff (e.g. background color)...but everything else seems to work as expected. Wondering if there is a way to mimic this but obviously without having to click through prompts about saving/losing features.
from importexcel.
Ah, so the save as in Excel when choosing csv, it keeps the $1,235.00
?
Without looking at the code I do believe Export-Excel returns the value
. I think text
has the formatting. Not sure how much.
Not sure how much may break if a param enables returning either one.
from importexcel.
Yes observationally it seems to keep all the desired format variations.
from importexcel.
Hey there @jhoneill. I'm mixing up params in my head between Import and Export -excel. There was no switch on Export-Excel to grab the .text
of a cell rather than .value
?
Time to do a spike test on this.
from importexcel.
Hey there @jhoneill. I'm mixing up params in my head between Import and Export -excel. There was no switch on Export-Excel to grab the
.text
of a cell rather than.value
?Time to do a spike test on this.
No ... we're generally sticking number / text / date / boolean and then applying formatting as distinct operation with Export.
Import is bringing each row in as an object so each cell in that row comes in as the number/date/string in .Value which is almost always what we want. Getting .text instead of .value would be easy enough
from importexcel.
@jhoneill thanks, yeah, thinking of adding something like [Switch]$AsText
then `$targetProperty = if($AsText) {'text'} else {'value'}.
Hopefully off to the races.
from importexcel.
Related Issues (20)
- 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 7
- 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 7
- Set-excelrange after export-excel with '-append' results in exception
- Worksheet Argument completer not working
- Conditional Formatting (Date) HOT 3
- Export-Excel -Clearsheet fails
- Powershell issue when opening file in x86 vs x64 HOT 8
- ImportExcel 7.8.7 cannot be imported, fails with loading of EPPlus.dll assembly HOT 9
- broken version pushed to powershellgallery HOT 11
- Feature Request: Apply Sensitivity Label HOT 1
- Import Sheet, including all formatting? HOT 3
- Documentation: many links broken in SUMMARY.md
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.