Microsoft Office Integration (Concept): Difference between revisions

Revision as of 16:03, 22 February 2021

2.9

This piece of functionality has undergone drastic changes since writing this article and the information may be outdated or inaccurate as of now.

Easier access to the contents of files from the worlds most used business application suite.

About

Microsoft Office integration allows a Grooper user to leverage the native text of files generated in the Microsoft Office Suite such as Microsoft Word documents and Microsoft Excel spreadsheets. This feature can pull the native text from and perform type-specific activities on these files.

Supported File Types

Microsoft Word documents (.docx)
Microsoft Excel spreadsheets (.xlsx)

Note: This feature does not support older, non-XML file types (.doc, .xls, etc.).

How to Use

To make use of this feature, ensure that Microsoft Office is installed on the machine running Grooper Design Studio.

Getting a Result

In Grooper Design Studio select a Batch that contains the desired documents.
Select the document whose native text you wish to view.
Use the object command Excel Document > Excel to CSV....
- The Excel to CSV command will add a child document object for each page in the native file.
- The Open command will literally open the file in whatever the native application is.
- The Save As command will simply let you save the file to somewhere in your file system out of Grooper.
In the subsequent Excel to CSV window that opens up, choose a Conversion Method.
- Burst will convert the Excel file to a CSV and saves the results as child object(s).
- SaveNew will convert the Excel file to a CSV and save the result as a new file.
- Convert will convert the native Excel file to a CSV and replace the native file.

Viewing the Results

In the image below you can see a Burst version of the document copied a few times showing a result for each PDF, Plain Text, and Rich Text.

Version Differences

Prior to Grooper 2.9 files from the Microsoft Office Suite had to be rendered (essentially a "print...") to PDF in order to view contents and use activities more effectively.

@@ Line 26: / Line 26: @@
 | style="padding:25px; vertical-align:top; width:35%" |
 # In '''Grooper Design Studio''' select a '''Batch''' that contains the desired documents.
-# Select the document you wish to view its native text.
+# Select the document whose native text you wish to view.
-# Use the object command <code>Word Document > Burst...</code>.
+# Use the object command <code>Excel Document > Excel to CSV...</code>.
-#* The '''Burst''' command will add a child document object for each page in the native file.
+#* The '''Excel to CSV''' command will add a child document object for each page in the native file.
-#* The '''Convert''' command will give you the same native text as '''Burst''', but will not create sub-document objects for each page. Instead, it will leave it as one document, with access to sub-pages view the '''[[Document Viewer]]'''.
 #* The '''Open''' command will literally open the file in whatever the native application is.
-#* The '''Render''' command will use the legacy "print to [https://en.wikipedia.org/wiki/PDF PDF]" style approach.
 #* The '''Save As''' command will simply let you save the file to somewhere in your file system out of '''Grooper'''.
-# In the subsequent '''Burst''' (or '''Convert''') window that opens up, pick a style of native text viewing for the '''''Output File Type''''' property.
+# In the subsequent '''Excel to CSV''' window that opens up, choose a Conversion Method.
-#* ''PDF'' will present the text in the style of a rendered .pdf.
+#* ''Burst'' will convert the Excel file to a CSV and saves the results as child object(s).
-#* ''Plain Text'' will present the text as if line by line in a [https://en.wikipedia.org/wiki/Text_file .txt] file.
+#* ''SaveNew'' will convert the Excel file to a CSV and save the result as a new file.
-#* ''[https://en.wikipedia.org/wiki/Rich_Text_Format Rich Text]'' will use the Microsoft proprietary text formatting to present the file.
+#* ''Convert'' will convert the native Excel file to a CSV and replace the native file.
 || [[File:Microsoft_office_integration_001.png]]
 |}