How to edit DsoFramer 1.3?
I am using DsoFramer 1.3 in my project to store Excel (2007) documents. But it has a big problem, that is:
All Excel documents opened by DsoFramer use only one Excel process. As a result, when the second Excel document is opened with DsoFramer, the first document cannot be modified.
Moreover, when I double-clicked an Excel document in Windows Explorer directly, the documents in DsoFramer will lose focus because only one excel.exe
in the Task Manager will get the latter.
Fortunately, microsoft provides source code for DsoFramer 1.3, although it doesn't support it. ( http://www.microsoft.com/downloads/details.aspx?FamilyId=CE2CA4FD-2169-4FAC-82AF-770AA9B60D77&displaylang=en .)
How to edit the source code and make it generate a new Excel process when you open an Excel document with dsoframer every time?
I tried using Steve's method but it doesn't work. DSOFramer closes the Excel document in another window. If unsaved data is in a file, dsoframer will not open with "Attempt to access an invalid address"
You can try SpreadsheetGear , which comes with Windows Forms control , which provides the ability to view, edit, format, print, etc. Xls and xlsx. We have several clients who have switched from DsoFramer to SpreadsheetGear for various reasons.
SpreadsheetGear has the concept of a collection of books, which is a collection of books and is roughly analogous to an instance of Excel. The number of book sets is limited only by the available memory. It also has a Windows Forms WorkbookView control. You can have multiple WorkbookViews, and each WorkbookView has its own workbook set by default (you can override this if you want multiple WorkbookViews to display the same set of books).
You can read more about SpreadsheetGear and download a free trial here .
Disclaimer: I own SpreadsheetGear LLC
a source to share