Jump to content

  • Log In with Google      Sign In   
  • Create Account


#ActualNypyren

Posted 10 October 2013 - 07:38 PM

Usually you have to save the Excel file out as some other format before beginning step 2. Dealing with Excel's native file format is kind of a pain, and writing an Excel plugin is no fun either.

The easiest is probably CSV, but "XML Spreadsheet 2003" (XMLSS) is also pretty easy to read and supports more of Excel's formatting information.

Step 2 consists more-or-less of the following sub-steps:

2a. Open the file in Excel, then "Save As" using the file type drop-down "XML Spreadsheet 2003". If you want, you can permanently keep the Excel spreadsheet in this format for editing as well, but it only supports a subset of Excel's features. For simple data entry and calculations, it will work fine.
2b. Use a program that you've written to load the .xml file, read each worksheet, row, and cell.
2c. Convert the data however you need to.
2d. Save the converted data in a file that your game will load later.


You'll want to examine the XMLSS file by hand to familiarize yourself with the format, and then write a loader which can read the portions you care about. There are a bunch of sections you won't care about at all. It's fairly human readable. The spec is here in case you need it: http://msdn.microsoft.com/en-us/library/office/aa140066(v=office.10).aspx

#3Nypyren

Posted 10 October 2013 - 07:38 PM

Usually you have to save the Excel file out as some other format before beginning step 2. Dealing with Excel's native file format is kind of a pain, and writing an Excel plugin is no fun either.

The easiest is probably CSV, but "XML Spreadsheet 2003" (XMLSS) is also pretty easy to read and supports more of Excel's formatting information.

Step 2 consists more-or-less of the following sub-steps:

2a. Open the file in Excel, then "Save As" using the file type drop-down "XML Spreadsheet 2003". If you want, you can permanently keep the Excel spreadsheet in this format for editing as well, but it only supports a subset of Excel's features. For simple data entry and calculations, it will work fine.
2b. Use a program that you've written to load the .xml file, read each worksheet, row, and cell.
2c. Convert the data however you need to.
2d. Save the converted data in a file that your game will load later.


You'll want to examine the XMLSS file by hand to familiarize yourself with the format, and then write a loader which can handle it. There are a bunch of sections you won't care about at all. It's fairly human readable. The spec is here in case you need it: http://msdn.microsoft.com/en-us/library/office/aa140066(v=office.10).aspx

#2Nypyren

Posted 10 October 2013 - 07:27 PM

Usually you have to save the Excel file out as some other format before beginning step 2. Dealing with Excel's native file format is kind of a pain, and writing an Excel plugin is no fun either.

The easiest is probably CSV, but "XML Spreadsheet 2003" (XMLSS) is also pretty easy to read and supports more of Excel's formatting information.

Step 2 consists more-or-less of the following sub-steps:

2a. Open the file in Excel, then "Save As" using the file type drop-down "XML Spreadsheet 2003". If you want, you can permanently keep the Excel spreadsheet in this format for editing as well, but it only supports a subset of Excel's features. For simple data entry and calculations, it will work fine.
2b. Use a program that you've written to load the .xml file, read each worksheet, row, and cell.
2c. Convert the data however you need to.
2d. Save the converted data in a file that your game will load later.


You'll want to examine the XMLSS file by hand to see which parts of it you want to use. There are a bunch of sections you won't care about at all. It's fairly human readable. The spec is here in case you need it: http://msdn.microsoft.com/en-us/library/office/aa140066(v=office.10).aspx

#1Nypyren

Posted 10 October 2013 - 07:21 PM

Usually you have to save the Excel file out as some other format before beginning step 2. Dealing with Excel's native file format is kind of a pain, and writing an Excel plugin is no fun either.

The easiest is probably CSV, but "XML Spreadsheet 2003" (XMLSS) is also pretty easy to read and supports more of Excel's formatting information.

PARTNERS