Geek Answers Handbook

Create XML with Excel support on iPhone

I want to create an XML file with Excel support in iPhone. How to insert an image into an xml file and the image is present in my resources folder? I want to attach this XML file by mail and send to others. Others should be able to open the XML file as an Excel sheet and see the text and images.

I followed this link to create an xml file.

+5
source share
1 answer

Well, your example shows the old Excel XML format used in Office 2003. However, double-clicking the default will in most cases open the file in an XML-related application, not Excel. "Real" Excel 2007+ "xlsx" is a ZIP archive with a set of xml files inside. If your excel file is relatively small and simple, I suggest you use the following approach:

  • Create an Excel template file with the desired content;
  • Extract the contents of the file and examine it. You need to repeat the row pattern with your data. You can search xml files for your data values ​​to easily find the data you need;
  • Find and study a repeating data pattern;
  • Create an XML template file to store your data (you can use some placeholders to place data);
  • , Excel, XML ( ) XLSX ( zip-), Excel , ().
+2

More articles:


All Articles