<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <meta name="Generator" content="Microsoft Word 14 (filtered medium)"> <style></style> </head> <body bgcolor="white" lang="ZH-CN" link="blue" vlink="purple"> <div class="WordSection1"> Hi Andrew and Fernand,<o:p></o:p> <o:p> </o:p> Thanks a lot for your help.<o:p></o:p> <o:p> </o:p> With your hint, I’ve found a way to get file path for all opened spreadsheet documents with Java, my code is as follow.<o:p></o:p> -------------------------------------------------------------------------------------------------------------------------------------------------------------------<o:p></o:p> <div style="mso-element:para-border-div;border:none;border-bottom:solid windowtext 1.0pt;padding:0cm 0cm 1.0pt 0cm"> String ooExeFolder = "/usr/lib64/libreoffice/program"; XComponentContext xContext = BootstrapSocketConnector.bootstrap(ooExeFolder); XMultiComponentFactory xMCF = xContext.getServiceManager(); Object desktop = xMCF.createInstanceWithContext("com.sun.star.frame.Desktop", xContext); XDesktop xDesktop = (XDesktop)UnoRuntime.queryInterface(XDesktop.class, desktop); XEnumeration xenum = xDesktop.getComponents().createEnumeration(); while(xenum.hasMoreElements()) { Object obj = xenum.nextElement(); XComponent x = (XComponent)UnoRuntime.queryInterface(XComponent.class, obj); XModel xm = (XModel)UnoRuntime.queryInterface(XModel.class, x); if (xm != null) { String url = xm.getURL(); //url is what I want System.out.println(url); } }<o:p></o:p> </div> <o:p> </o:p> Best Regards<o:p></o:p> William<o:p></o:p> <o:p> </o:p> ---------------------------------------------------------------------------------------------------------------------------------------------------------------------<o:p></o:p> From: SOS [mailto:sos@pmg.be] Sent: 2015年6月11日 0:52 To: Zhang, William; users@global.libreoffice.org Subject: Re: Q: How to get the path of all opened spreadsheet documents<o:p></o:p> <o:p> </o:p> <o:p> </o:p> Zhang in basic i use this function Function TaskonDesktop(DocPath as String) as Boolean Dim oComponents as Object ' Search if one of the active Components ist the one that you search for oComponents = StarDesktop.Components.CreateEnumeration While oComponents.HasmoreElements oComponent = oComponents.NextElement 'print UCase(oComponent.URL) & " - " & UCase(converttoURL(DocPath) If UCase(oComponent.URL) = UCase(converttoURL(DocPath)) then TaskonDesktop = True Exit Function End If Wend TaskonDesktop = False End Function hope it helps Fernand<o:p></o:p> <o:p> </o:p> <o:p> </o:p> <div> <div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm"> From: Andrew Douglas Pitonyak [mailto:andrew@pitonyak.org] Sent: 2015年6月8日 19:20 To: Zhang, William Cc: libreoffice@lists.freedesktop.org Subject: Re: Q: How to get the path of all opened spreadsheet documents<o:p></o:p> </div> </div> <o:p> </o:p> 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 <o:p></o:p> <div> On 06/07/2015 09:21 PM, Zhang, William wrote:<o:p></o:p> </div> <blockquote style="margin-top:5.0pt;margin-bottom:5.0pt"> 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 href="mailto:andrew@pitonyak.org">mailto:andrew@pitonyak.org</a>] Sent: 2015年6月5日 19:15 To: Zhang, William Cc: <a 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> <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 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> </blockquote> <o:p></o:p> <pre>-- <o:p></o:p></pre> <pre>Andrew Pitonyak<o:p></o:p></pre> <pre>My Macro Document: <a href="http://www.pitonyak.org/AndrewMacro.odt">http://www.pitonyak.org/AndrewMacro.odt</a><o:p></o:p></pre> <pre>Info: <a href="http://www.pitonyak.org/oo.php">http://www.pitonyak.org/oo.php</a><o:p></o:p></pre> </div> </body> </html>