![]() ![]() ![]() FET file and its related (generated) ACTIVITIES.XML into the Excel sheet itself its very useful if you need to re-layout the timetable and need to adapt. so great.īut, now my buddy on his mac with 2011 excel, says it doesnt work.Īnd He's the guy that needs to generate the report for the board. It is an old Office 2010 Excel sheet with a macro (with Italian comment and Italian labeling for variable names, so not fully comprehensive for an international developer) that can import a. So I started poking around in excel and, well, I got it to work. Pretty obvious clue, even for a fool like me. ![]() I can say that the XML exports from our website are formmatted in some Office XML, because in the header i noticed the following lines: mso-application progid="Excel.Sheet"? Workbook xmlns:x="urn:schemas-microsoft-com ffice:excel" xmlns ="urn:schemas-microsoft-com ffice ffice" xmlns:ss="urn:schemas-microsoft-com ffice:spreadsheet" I figured this out as I was looking at the file header trying to figure out how the heck to make an xml readable, easily. I read some post talk about using data>get ext data>, but theres definitely no option for an xml at that level on my version.īut as mentioned, the first path worked for me. It works for me in 2008 mac excel, but my buddy on 2011 mac excel says he cant get it to work.įor me, I did the following and it works as expected:įile>Import> (pop-up window with four options csv,fmp,html,txt) choose HTML File>enable all office documents>choose your xml file. Curious if anyone has had any luck with this? ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
May 2023
Categories |