Features inquiry

Aspose.Cells Product Family
1

Does the cells library have access to any of the following:

  • document properties (file -> properties)
    • general
    • summary
    • statistics
    • contents
    • custom
  • stored database queries (data -> import external source)
  • linked objects (insert -> object -> create from file)
    • link to file (not the file itself)
  • macros and code (tools -> macro)
  • office guid (only excel 97)
  • printer setup information (print options)
  • routing slips (file -> send to -> routing recipient)
    • email addresses
    • usernames
  • scenario comments (tools -> scenarios)
    • comments
  • passwords
    • weak protection passwords stored as text

2

Hi,

Thanks for considering Aspose,

  • document properties (file -> properties)

    • Yes, please check:

    http://www.aspose.com/Wiki/default.aspx/Aspose.Cells/WorkingWithDocumentProperties.html

      stored database queries (data -> import external source)
      For importing data from external source you may use Cells.ImportDataTable() or other methods.

      http://www.aspose.com/Wiki/default.aspx/Aspose.Cells/ImportData.html

  • linked objects (insert -> object -> create from file)

    • Yes, please check:

    http://www.aspose.com/Wiki/default.aspx/Aspose.Cells/OtherDrawingObjects.html#OleObject

  • macros and code (tools -> macro)
    No, we don't support to create macros although Aspose.Cells support to preserve macros and vba code when you load a template file using the component. So you may create it manually in MS Excel and Aspose.Cells will preserve it and save the file with it. Only you may delete workbook macros using Workbook RemoveMacro method.

  • printer setup information (print options)

    • Still to be supported, although pagesetup options are supported by the component.

  • routing slips (file -> send to -> routing recipient)

    • No, the feature is not supported.

    passwords

    • weak protection passwords stored as text

    Yes you may protect the whole workbook or induvidual worksheets in the book.

    Thank you.


    3
    I was asking about these features in reference to extracting them as information, not storing any new data.

    The hope is to extract any usable information for indexing and searching to reveal usernames, email, and network share names.