Using Microsoft Office files in DISE

From DISE KnowledgeBase

Jump to: navigation, search

Contents

Overview

DISE does not currently support direct usage of Microsoft Office files but it is possible to export the files from Microsoft Office so that they are then usable in DISE. These instructions where tested using Microsoft Office 2003/2007/2010.

Info.png Read more: Microsoft Office - Microsoft.com

If you have any other tips of how to use Microsoft Office files in DISE, or if there are any differences doing these things in other versions of MS Office then please Contact support with the information and we will be happy to include it here.

Microsoft Excel

Export as web page

  1. Open the Excel file.
  2. Select File / Save as Web Page.
  3. Click the Publish button.
  4. Choose the item to publish, if you would like to select a certain sheet select "Items on".
  5. Select "Sheet" if you want to export the complete sheet.
  6. Click Browse to select where the file should be saved, change the "Save as type" to "Single File Web Page" and make sure that the file extension is .mht or .mhtml.
  7. If you would like to make sure that any changes to this sheet are saved automatically when something changes check the "AutoRepublish" check box.
  8. This created .mht or .mhtml file can then be added to DISE in the Web Page Object.

Save as .CSV

  1. Open the Excel file.
  2. Select File / Save as
  3. Select file format: CSV-file.
  4. Use the csv file with the data connection function to get the data into DISE. Remember to select the Column processing box and in the Field delimiter field, enter the delimiter used when exporting (; by default)

You can still edit the .csv file in Excel after exporting, but any formatting information will be lost when you save.

Export a chart to image

  1. Open the Excel document and select the chart you would like to export.
  2. Copy the chart by pressing Ctrl+C or selecting Edit / Copy.
  3. Open some kind of graphic editing software and paste the image there.
  4. Save the image and add to DISE in an Image Object.
  5. It is also possible to add several charts in a slide show by using the List Object.

Word

Export as a web page

  1. Open the Word file.
  2. Select File / Save as Web Page.
  3. Click Browse to select where the file should be saved, change the "Save as type" to "Single File Web Page" and make sure that the file extension is .mht or .mhtml.
  4. This created .mht or .mhtml file can then be added to DISE in the Web Page Object.


PowerPoint

Info.png Read more: Importing PowerPoint slides

Retrieved from "https://kb8.dise.com/index.php?title=Using_Microsoft_Office_files_in_DISE&oldid=10896"