<html> <head> <meta content="text/html; charset=utf-8" http-equiv="Content-Type"> </head> <body bgcolor="#FFFFFF" text="#000000"> Calc documents implement the following service: com.sun.star.sheet.SpreadsheetDocument Using that with the examples below based on a write document: '****************************************************************************************** '// Count the total number of open componets. '// This includes all document types as well '// as things such as the Basic IDE and help windows. '****************************************************************************************** Function numberOfOpenComponents As Integer Dim i As Integer Dim oDocs Dim oDoc i = 0 oDocs = StarDesktop.getComponents().createEnumeration() Do While oDocs.hasMoreElements() oDoc = oDocs.nextElement() i = i + 1 Loop numberOfOpenComponents = i End Function '****************************************************************************************** '// Count number of open Write documents. '****************************************************************************************** Function countOpenWriteDocs() As Integer countOpenWriteDocs = countTypedComponents("com.sun.star.text.TextDocument") End Function '****************************************************************************************** '// Count number of documents that are open with the specified service type. '****************************************************************************************** Function countTypedComponents(serviceName$) As Integer Dim i As Integer Dim oDocs Dim oDoc i = 0 oDocs = StarDesktop.getComponents().createEnumeration() Do While oDocs.hasMoreElements() oDoc = oDocs.nextElement() If oDoc.supportsService(serviceName) Then i = i + 1 End If Loop countTypedComponents = i End Function '****************************************************************************************** '// Return true if the specified document is a Write document. '****************************************************************************************** Function isWriteDocument(oDoc) As Boolean If IsNull(oDoc) Then isWriteDocument = False ElseIf IsEmpty(oDoc) Then isWriteDocument = False ElseIf oDoc.supportsService("com.sun.star.text.TextDocument") Then isWriteDocument = True Else isWriteDocument = False End If End Function <div class="moz-cite-prefix">On 06/07/2015 09:21 PM, Zhang, William wrote: </div> <blockquote cite="mid:BY2PR05MB19279A75C691291FBD18FA83B4BF0@BY2PR05MB1927.namprd05.prod.outlook.com" type="cite"> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <meta name="Generator" content="Microsoft Word 14 (filtered medium)"> <style></style> <div class="WordSection1"> Hi Andrew,<o:p></o:p> <o:p> </o:p> Thanks a lot for your reply.<o:p></o:p> <o:p> </o:p> Q1: In your case do you only care about documents that have been saved... Ignoring new never saved to disk docs?<o:p></o:p> àWhat I want to get is all calc documents as long as the doc is opened, no matter it have been saved or not.<o:p></o:p> So firstly, I want to know if it’s possible to do it in this case. If no, maybe I can only care the doc which have been saved and ignore which is not saved.<o:p></o:p> <o:p> </o:p> Q2: You enumerate the open components from the desktop object and check of the component is a calc document.<o:p></o:p> àSorry, I know how to get the desktop object, but I am not clear how to get the open component and check them as you mentioned.<o:p></o:p> This is my gap, would you please give example code based on my comment for Q1?<o:p></o:p> <o:p> </o:p> Thanks in advanced! <o:p></o:p> Best Regards<o:p></o:p> William<o:p></o:p> -----Original Message----- From: Andrew Pitonyak [<a class="moz-txt-link-freetext" href="mailto:andrew@pitonyak.org">mailto:andrew@pitonyak.org</a>] Sent: 2015年6月5日 19:15 To: Zhang, William Cc: <a class="moz-txt-link-abbreviated" href="mailto:libreoffice@lists.freedesktop.org">libreoffice@lists.freedesktop.org</a> Subject: Re: Q: How to get the path of all opened spreadsheet documents <o:p> </o:p> No time to find the solution now.... But I have done this sort of thing in basic.<o:p></o:p> <o:p> </o:p> You enumerate the open components from the desktop object and check of the component is a calc document.<o:p></o:p> <o:p> </o:p> In your case do you only care about documents that have been saved... Ignoring new never saved to disk docs?<o:p></o:p> <o:p> </o:p> Think I can find a basic example of it helps<o:p></o:p> <o:p> </o:p> On Jun 4, 2015 10:35 PM, "Zhang, William" <<a moz-do-not-send="true" href="mailto:william.zhang@ptn.advantest.com">william.zhang@ptn.advantest.com</a>> wrote:<o:p></o:p> ><o:p> </o:p> > Hi,<o:p></o:p> ><o:p> </o:p> > <o:p></o:p> ><o:p> </o:p> > Request:<o:p></o:p> ><o:p> </o:p> > In RedHat7, I want to get the path of all opened spreadsheet documents with Java.<o:p></o:p> ><o:p> </o:p> > <o:p></o:p> ><o:p> </o:p> > What I’ve done:<o:p></o:p> ><o:p> </o:p> > 1. I used Runtime.exec(cmd…) with Java code, the ‘cmd’ was defined with “ps –ef | grep xxx”<o:p></o:p> ><o:p> </o:p> > ->if only one spreadsheet document opened, the returned info list the correct document, I can parse it and get the file path<o:p></o:p> ><o:p> </o:p> > ->but if multi spreadsheet documents opened, the returned process still only list the first document, I cannot get other documents.<o:p></o:p> ><o:p> </o:p> > 2. I also test in bash, it seems “ps -ef” cannot list all files.<o:p></o:p> ><o:p> </o:p> > <o:p></o:p> ><o:p> </o:p> > So , I want to know is there any other way to do it. such as using UNO service with libreoffice API to get it.<o:p></o:p> ><o:p> </o:p> > Anyone who knows it is much appreciate.<o:p></o:p> ><o:p> </o:p> > <o:p></o:p> ><o:p> </o:p> > Best Regards<o:p></o:p> ><o:p> </o:p> > William<o:p></o:p> ><o:p> </o:p> > <o:p></o:p> </div> </blockquote> <pre class="moz-signature" cols="72">-- Andrew Pitonyak My Macro Document: <a class="moz-txt-link-freetext" href="http://www.pitonyak.org/AndrewMacro.odt">http://www.pitonyak.org/AndrewMacro.odt</a> Info: <a class="moz-txt-link-freetext" href="http://www.pitonyak.org/oo.php">http://www.pitonyak.org/oo.php</a> </pre> </body> </html>