Salakhetdinov Shamil
mcp2004 at mail.ru
Thu Jan 29 06:26:08 CST 2015
Hi Arthur, <<< I would be most happy to learn from listers how to achieve this result on either of these free equivalents. Any ideas? >>> You can use Open Xml SDK: https://github.com/OfficeDev/Open-Xml-Sdk https://msdn.microsoft.com/en-us/library/office/bb448854.aspx A couple+ of years ago have used it to develop custom apps for my customer .docx and .xlsx templates/documents/workbooks, and it worked very well. There are quite a few tutorials available - you can use C# or VB.NET: https://msdn.microsoft.com/en-us/library/office/hh180830%28v=office.14%29.aspx Here are tutorials I used in the past: http://ericwhite.com/blog/open-xml-sdk-expanded/ Here are Python and Java (another SDK) tools: http://www.opendocumentformat.org/developers/ ... Thank you. -- Shamil Thursday, January 29, 2015 5:51 AM -05:00 from Arthur Fuller <fuller.artful at gmail.com>: >You're probably right on all counts, John; that said, the new CEO, Satya >Nadella, seems to have got it right, IMHO. The free release of the next >Windows upgrade is IMO a portent for the future. MS is a corporation with a >responsibility to its shareholders, which means they must end up in the >black ink rather than the red. But they can do that bundling Windows with >laptops and tablets and even phones. and with Office atop that, they're >pretty much home-free. OpenOffice and OfficeLibre are players, to be sure, >but let's face it, they are small players: MS Office owns the roost. > >I champion the efforts of OpenOffice and OfficeLibre, but my personal and >client-problem is that I have developed a bunch of Office-Integration code >that blends Word, Access and Excel into powerful solutions, and I cannot as >yet achieve these results in either OpenOffice or OfficeLibre. Both these >products go just as far as the end user is concerned, and ignore the >situation where 500 users are involved. > >Frankly, I have no idea how OpenOffice or OfficeLibre can surmount this >gap, but until they figure it out, I can't recommend replacing the MS >Office suite with either of these babies. > >One case in point. A few years back I wrote an Excel app for an investment >corporation. The app visited about 100 folders and opened the Excel >workbooks therein, grabbing the totals from various pages, and created a >new WorkBook consisting of about 100 sheets, one for each investment fund, >each containing last year's monthly results and this year's monthly >results. > >I cannot do that in either OpenOffice or OfficeLibre (well, maybe it's >possible but I haven't yet figured out how). So thus far, I cannot >recommend replacing MS Excel with their free replacements. > >I would be most happy to learn from listers how to achieve this result on >either of these free equivalents. Any ideas? > >A.