Hey Since you use it daily maybe you can help me? I have a csv which i want to export into Excel. However the Delimiter are ; which from my tests so far doesn't automaticly work. Import-Csv $FilePath | Export-Excel $xlsx -AutoSize Is what i try to do. However everything from the csv just gets put into the first column
However i have a feature missing here... I'm tring to fill an Excel table in a sheet, then i have a pivot table in another sheet referring the Excel table filled before but when i open my final Excel file it ask me always if i want to refresh my pivot... is there a way to update automatically the pivot ?
Fantastic module! I have an issue, though, that if I do a named @reference in a formula it's not making it to the spreadsheet, it just shows up as #ref, although referencing a named range seems to work fine. When I pipe to CSV the @reference works, but not when I pipe to Excel.
We are about to migrate users' HomeDir to a new server (plus using DFS for next time). Without installing Excel can I use import-excel to search formulas for “w?:\w*\[w*.xlsw?]” ? Thanks
hello doug how can i copy the values from pivot table and save it to another workbook (.xlsx) or another csv file i only want the data from pivot table
Hello Raymond. Not sure if this will work for a Pivot table, they are a bit different. You need to get access to the workbook and worksheets you want to work with, and then the cells. Something like: $xlpkg = $data | Export-Excel test.xlsx -PassThru $v = $xlpkg.PivotSheet.Cells["A1"].Value $xlpkg.TargetSheet.Cells["A3"].Value = $v Close-ExcelPackage $xlpkg
hey i want to take data for chart from 3 different column how to pass that column , for example i want to draw a bar graph where col 1 = 24 , col2= 56, col3=67 show how to draw graph from that data
I need to convert xls to csv without Excel installed on my server. The PowerShell module ImportExcel is working fine , but only with .xls not .xlxs. Using this command : PS C:\WINDOWS\system32> import-excel c:\powershell_test\files\i_sensys.xls | ft gives me the message : Import-Excel does not support reading this extension type .xls How can I convert xls to xlsx without Excel installed before using the module ImportExcel thanks
I use Doug's module daily. Thanks for the demos. Picked up a few tricks.
Hey Since you use it daily maybe you can help me? I have a csv which i want to export into Excel. However the Delimiter are ; which from my tests so far doesn't automaticly work.
Import-Csv $FilePath | Export-Excel $xlsx -AutoSize
Is what i try to do. However everything from the csv just gets put into the first column
Holy cow! Just come across this module while looking for a way to dump some data into something more useful than raw CSV. Incredible work!
However i have a feature missing here... I'm tring to fill an Excel table in a sheet, then i have a pivot table in another sheet referring the Excel table filled before but when i open my final Excel file it ask me always if i want to refresh my pivot... is there a way to update automatically the pivot ?
Fantastic module! I have an issue, though, that if I do a named @reference in a formula it's not making it to the spreadsheet, it just shows up as #ref, although referencing a named range seems to work fine. When I pipe to CSV the @reference works, but not when I pipe to Excel.
We are about to migrate users' HomeDir to a new server (plus using DFS for next time). Without installing Excel can I use import-excel to search formulas for “w?:\w*\[w*.xlsw?]” ? Thanks
hello doug how can i copy the values from pivot table and save it to another workbook (.xlsx) or another csv file
i only want the data from pivot table
Hello Raymond. Not sure if this will work for a Pivot table, they are a bit different. You need to get access to the workbook and worksheets you want to work with, and then the cells.
Something like:
$xlpkg = $data | Export-Excel test.xlsx -PassThru
$v = $xlpkg.PivotSheet.Cells["A1"].Value
$xlpkg.TargetSheet.Cells["A3"].Value = $v
Close-ExcelPackage $xlpkg
How do you make multiple sheets?
hey i want to take data for chart from 3 different column how to pass that column , for example i want to draw a bar graph where col 1 = 24 , col2= 56, col3=67 show how to draw graph from that data
Can you please explain the difference between this and pandas?
I need to convert xls to csv without Excel installed on my server. The PowerShell module ImportExcel is working fine , but only with .xls not .xlxs.
Using this command : PS C:\WINDOWS\system32> import-excel c:\powershell_test\files\i_sensys.xls | ft
gives me the message : Import-Excel does not support reading this extension type .xls
How can I convert xls to xlsx without Excel installed before using the module ImportExcel
thanks