Re: [libreoffice-users] Trying to make a macro

Hola jorge  : )

On Sat, 27 Aug 2016 05:47:09 +0000, jorge escribió:

J> Good evening:

' Afternoon.
I'm also interested in importing .txt files into a spreadsheet adequately.

J> I try to make a macro in Calc to insert a sheet from a file in .txt
J> format or .csv using the LO process: Record macro.

Mm. A question: are you trying to make a macro because you plan to be
importing a file regularly or is it just a one-time import?

Or are you trying to import it as an exercise on how to make macros?

J> I did it but the macro run and stop in the directory where the file is,
J> but not record the select and not open the sheet although I did when I
J> recorded the macro.

I notice that you call your .csv file a "sheet" and I think it is not
a sheet, yet, but a text file.

J> The code that the process wrotten is this, would you please guide me to
J> finish:

I'm afraid I am not that familiar yet with macros, but it seems to me that
at some point the macro will ask you to select which file to import, right?
That is, a dilague window will appear to let you choose the kind of import
(separators, ...)   ...    Wait, I cannot find an "Import" option in
menus.  : ! ? 

Let's see:

J> REM  *****  BASIC  *****
J> 
J> sub Main
J> rem
J> ----------------------------------------------------------------------
J> rem define variables
J> dim document   as object
J> dim dispatcher as object
J> rem
J> ----------------------------------------------------------------------
J> rem get access to the document
J> document   = ThisComponent.CurrentController.Frame
J> dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")
J> 
J> rem
J> ----------------------------------------------------------------------
J> rem dispatcher.executeDispatch(document, ".uno:InsertSheetFromFile", "",
J> 0, Array())
J> 
J> end sub

There, at the end you have a ".uno:InsertSheetFromFile"

¿How did you manage to "import" a file into your worksheet? I've only
managed it _opening_ a new file which is a .cvs file. And then the import
dialogue appears, I choose the options and the .csv file is correctly
imported into a worksheet.

As I say I'm not familiar with macros and don't know how that is done. But
It seems to me that perhaps you have to open a file instead of trying to
import it  : ?

I hope someone who already does what you want illustrates us on what is to
be done and how.

J> I use LibreOffice version 4.2.8.2 on Ubuntu 14.04 LTS

I'm using LO Versión: 4.3.3.2 on Debian GNU/Linux 8.5.

Felipe  : )

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted