I was re-reading the excellent book by The Italians over the weekend. But I have to say I was wrong about this and I think there is a lot of value in this second option for Excel users. Very early on I dismissed this as being “not useful” for Excel users of Power Pivot (although I could clearly see the benefit for SQL professionals that could already write SQL code). The second option in the Table Import Wizard is a case in point. And some of the things that I dismissed as “not useful” very early on have turned out to be very useful indeed. Excel 2000 or higher required.I have learnt a lot over the last year working full time as a Power Pivot professional. Specify local XML files, and either insert them all into one sheet or individual sheets per file. Import one or more XML files into a blank MS Excel file. How to Import Multiple XML Files To Excel File.Specify local Word files, and either insert them all into one sheet or individual sheets per file. Import one or more MS Word files into a blank MS Excel file.
Specify local text files and either insert them into one sheet or individual sheets per file.
Import one or more CSV files into a blank MS Excel file.
0 kommentar(er)
