Decimal separator after CSV import
Hi, I need some help, please. I'm trying to import a csv file. The problem is that numbers are written with comma decimal separator, but my PC is working with dots as decimal separator. In the previous Excel versions, there was the possibility to convert them during the import wizard. Unfortunately, I'm not able to find the same option in the new import wizard (Power Query). Thanks for all your answers LucaWhat's the difference between "CSV-File (.csv)" and "Microsoft Excel-CSV-File (.csv)"?
Hi, I have noticed that a .csv file opens differently on my two machines. On machine A) the opened file displays everything in separate columns: On machine B) the opened file displays everything in the same column: I can't figure out why that is. The Windows and Office versions on both machines are identical. Windows: 1709 (Build 16299.431) Office: 1802 (Build 9029.2253 CTR) I noticed that the file icon is different on both machines. Machine A): Machine B): Moreover, I file type (Dateityp) seems to be different (please don't mind the German): Machine A) says "CSV-Datei": Machine B) says "Microsoft Excel-CSV-Datei": Furthermore, I opened the file in Excel Online and it opens like on Machine B). One more thing I did is use PowerShell Get-Service | Export-Csv "C:\users\[xxx]". I would expect each property to show in it's own column. It does that on machine A) but not on B). I have attached the file for you to test it. Ideally I would like the file to opened on every machine as it does on A). Thanks in advance for your help.
Excel Import 32 bit vs 64 bit
I currently use the 32 bit excel, which I believe only allows use of 2gb or ram. This is extremely frustrating when working in large spreadsheets. I've requested from my IT department an upgrade to 64 bit. Their response is that our accounting system does not support the 64 bit. My question is how would a separate system be effected by the use of 64 bit vs 32 bit? I understand an add-in needing a certain excel version but would exporting reports from our accounting system to csv. or xls. be effected by 32 vs 64 bit excel? Wouldn't I be able to export a report to csv. then open in excel no matter the version?
Flow Exporting .CSV File from Azure Blob to SharePoint site (Power BI Data Export)
Hello, First of all sorry if this question was already asked. I was searching about this on Tech community and Google but nothing helped me. We worked on a simple Flow that export .CSV data File from Azure Blob to SharePoint site. With 3 of 4 exports it works just fine ! The last one is showing an error (screenshot below) We tried to remake it from scratch but nothing changed. Have you any idea on what the problem can be ? Thanks a lot in advance, Regards
Massive load of documents into a library - PNP
Hello, I wonder if somebody has prepared a script for performing a massive load of documents into a library. I have the documents available in a windows folder. I have a csv with the file name and several mandatory properties for every file. I have to use PNP. Thanks!
