none
[IPersistStorage] Open workbook (.xlsx) with stream. RRS feed

  • Question

  • Firstly my goal is "working with excel only with streams".

    That works:

    I successfully saved data from workbook (xlsx) to my stream via IPersistStorage where stream name (pwcsName) is "Package" (ignoring Component Object Stream \001CompObj). After this i saved it to xlsx file, that almost equals to original file, and file keep working. CreateILockBytesOnHGlobal-> StgCreateDocfileOnILockBytes->iPersistStorage.Save().

    Problem:

    From 2007 xlsx is not compound object, and passing zip data to persistStorage.Load() inside storage not working.

    My IStorage realization catch OpenStream invocation on Load() with pwcsName "Pack", (also i got "o", etc... but i forgot how i did it) and i don't know what i need to pass to workbook or even "if my goal is realizable".

    "\001CompObj" stream exist in msdn documentation, but "Pack" and others aren't.

    __________

    Can i open xlsx workbook with stream?

    Tuesday, January 21, 2020 3:00 PM