Skip to main content
100%

Macro script to rename file on libre office. You should put this file on "C:\Program Files (x86)\LibreOffice 5\share\Scripts\python" and insert it as macro on toolbar.

✓ Published0🌍 Public
Aalbcunha
Last edited Feb 7, 2017
Created on Feb 7, 2017

This macro script for LibreOffice renames the current document through a custom dialog, saving it under a new name and deleting the original file. It demonstrates the use of the Uno API to access the desktop, current document, and dialog controls, along with utility functions like `fileUrlToSystemPath`, `storeToURL`, and `loadComponentFromURL`. The script also employs `zipfile` and `os` for file operations, though their roles are not explicitly shown in the visible logic. It relies on Python’s `uno` module and the `com.sun.star.awt` interfaces for dialog creation and event handling.

AI-generated description

Similar vizzes

Loading thumbnail…

Rename files in a directory by removing non-alphanumeric characters that shouldn't be in a filename.

This example shows a Python script that recursively renames files and directories by replacing whitespace with underscores and stripping non-alphanumeric characters except periods, underscores, and hyphens. It walks the file system using `os.walk` and applies regular-expression substitutions via the `re` module, then moves each item with `shutil.move`. The script operates on user-specified directories or the current working directory, printing each rename action to standard error as it proceeds.

LLeeMendelowitz
50% match
Loading thumbnail…

Renaming files in many sub-folders. Requirement: There is a huge directory list which has many sub-directories and one file in each sub-directory, which has to be renamed as sub-directory name with the original extension. Last sub-directory name is always 8 chars. After renaming is done, it has to be moved to a different folder. Wrote a small Python utility for this requirement.

This example demonstrates a Python utility that renames a single file inside each sub-directory to match the sub-directory name while preserving the original extension, then moves it to a destination folder. It shows how `os.walk` traverses the directory tree, identifies the last 8 characters of each sub-directory name via string slicing, and uses `os.rename` to relocate and rename the file to `D:/GBR/`. The code relies on the standard `os` library for file system operations.

PP7h
49% match
Loading thumbnail…

Add a prefix to all the filenames in a directory

This example demonstrates a simple file-renaming script that adds a prefix to every text file in the current directory. The code uses Python’s `glob` module to collect all filenames ending in `.txt` and then applies `os.rename` to prepend the string `brad_` to each file. The process is iterative, renaming files one by one in place, with no rendering or data visualization involved.

Aamundo
46% match
Loading thumbnail…

Pandoc bash conversion

This visualization demonstrates a user’s workflow of converting and renaming files across directories using shell commands. It shows three distinct bash operations: deleting HTML files in a specific folder, converting sociology files to DOCX via Pandoc, and renaming XML files to HTML using the `rename` utility. The code relies on standard shell scripting constructs and the Pandoc command-line tool, with no graphical or interactive rendering libraries like D3 or Three.js. The data source is the local file system paths referenced in each command, and the rendering approach is purely textual—showing the raw bash scripts rather than any visual output.

CCliffordAnderson
43% match
Loading thumbnail…

Excel Macro for exporting all sheets as csv

This example presents a VBA macro that exports every worksheet in an Excel workbook to a separate CSV file. It iterates through each sheet using a `For Each` loop over `Application.ActiveWorkbook.Worksheets`. For each sheet, it copies the sheet to a new workbook and saves it with the sheet’s name using the `SaveAs` method with `FileFormat:=xlCSV`. The macro then closes the temporary workbook, leaving the original file untouched.

LLeeMendelowitz
42% match
Loading thumbnail…

[创建临时文件和文件夹] #python

This example demonstrates four Python recipes for creating temporary files and directories using the `tempfile` module. It shows anonymous temporary files via `TemporaryFile`, named temporary files with `NamedTemporaryFile` and its configurable `prefix`, `suffix`, and `dir` parameters, and temporary directories through `TemporaryDirectory`. The code also queries the system’s temporary file location with `gettempdir()`. Each use case is illustrated with a `with` block, emphasizing automatic cleanup, and the example writes and reads text to confirm functionality.

SShawn91
41% match
Loading thumbnail…

How to deal with renaming invalid UTF8 characters in directories or files

This example demonstrates a command-line workflow for detecting and renaming files with invalid UTF-8 characters, likely originating from latin-1 (ISO-8859-1) encodings. It first uses a Perl one-liner with a regular expression to filter filenames containing non-UTF-8 byte sequences, then applies the `rename` utility with Perl’s `Encode` module to convert those names from latin-1 to UTF-8. The process also references `iconv` and `recode` for verification. The solution relies on Unix shell scripting, piping `find` output through the filters, and handling character encoding transformations at the filesystem level.

TThomasG77
41% match
Loading thumbnail…

POC pour rechercher remplacer des URLS dans un projet QGIS

This example shows a Python script that migrates QGIS project files by replacing old French geoportal URLs with new ones in both .qgs and .qgz formats. It first searches and replaces URL pairs directly in .qgs text, and for .qgz archives, it unpacks the zip, applies the same replacement to embedded .qgs files, then repacks the archive. The tool uses standard library modules `argparse`, `tempfile`, `shutil`, and `pathlib` to handle file operations and globbing, while string replacement is done with `str.replace()`.

TThomasG77
40% match