User Tools

Site Tools


fsheets

fSheets

fSheets generates spreadsheets (xlsx) based on data gathered using fData. You can generate a spreadsheet in one of three ways:

  • Directly based on the contents of a DSD
  • Based on a template spreadsheet used to design the layout and content
  • Based on the contents of an fDocs template

By DSD

You can generate spreadsheets based on a default layout to include all of the data that the DSD includes (but not any internal data groups).

Based on an fSheets Template

With the fSheets Designer you can start a template and edit it to design the layout and content of the generated spreadsheet. Spreadsheets may then be generated based on this designed layout.

Based on an fDocs Template

You can generate a spreadsheet as an alternative format when generating an fDocs document.

If an fSheets template has been designated as the fDocs template's substitute then that will be used as the layout. Otherwise the layout will be based on a default (as when generating from a DSD) but the content is limited to just those values that are included in the fDocs template. In this case, it is effectively a spreadsheet containing the data that’s in the fDocs document.

fSheets Designer

fSheets templates are designed directly in Microsoft Excel ™.

Click on the “Design” button to start designing.

To save and use your design click on “Upload”.