SHIFT

--- Sjoerd Hooft's InFormation Technology ---

User Tools

Site Tools


Sidebar

Sponsor:


Recently Changed Pages:

View All Pages


View All Tags







WIKI Disclaimer: As with most other things on the Internet, the content on this wiki is not supported. It was contributed by me and is published “as is”. It has worked for me, and might work for you.
Also note that any view or statement expressed anywhere on this site are strictly mine and not the opinions or views of my employer.


Pages with comments

PageDateDiscussionTags
2019/11/18 13:52 1 Comment

View All Comments

start

SHIFT - Sjoerd Hooft's InFormation Technology

This WIKI is part of SHIFT. If you want to post comments, Sign up for Q. Q is the best way to practice your IT exams. A distraction free exam trainer with the option to post comments and even add questions yourself for free access. Give it a try and sign up for two weeks of free access!


PowerShell: Convert Excel File to CSV with Special Delimiter

Or actually, save an excel file as CSV and then recreate it with a specific delimiter:

cd "D:\filedir\"
$Excel = New-Object -ComObject Excel.Application
$Excel.visible = $false
$Excel.DisplayAlerts = $False
$file = "D:\filedir\excelfile.xlsx"
$csv = "D:\filedir\excelfile.csv"
$csvfinal = "D:\filedir\excelfilefinal.csv"
$workfile = $Excel.Workbooks.open($file)
$Sheet = $workfile.Worksheets.Item(1)
$Sheet.Activate()
$Sheet.SaveAs($csv,[Microsoft.Office.Interop.Excel.XlFileFormat]::xlCSVWindows)
$workfile.Close()
sleep 5
$Excel.Quit()
[System.Runtime.Interopservices.Marshal]::ReleaseComObject($excel)
Import-Csv $csv | Export-Csv $csvfinal -Delimiter ";" -NoTypeInformation
2019/11/28 13:38 · sjoerd

Use PowerShell with SharePoint Online Lists and Office DocProperties

The script below retrieves information from sharepoint online lists and puts that in prepared office files using docproperties.

→ Read more...

2019/11/21 09:50 · sjoerd

Sjoerd Hooft

So this is my official technical website, with all technical documentation! If you have a comment, please email me on sjoerd@getshifting_com (replace the _ by .)

2019/11/18 13:36 · sjoerd

Discussion

Enter your comment. Wiki syntax is allowed:
W T᠎ D F C
 
start.txt · Last modified: 2019/11/18 12:25 (external edit)