Stack Overflow
Stack Overflow

Questions tagged [xlm]

NOT to be confused with XML, nor xlsm, nor xmlns, nor other ?xml s. XLM is the standard file extension in Windows for macros and UDFs recorded in versions prior to Excel 5 (1993) where it remained an option until, with Excel 7 (the next version – released 1995), replaced by VBA. Microsoft discourages the use of XLM but it has features, still functional in recent Excel versions, that may at times be more convenient than VBA.

44 questions
15
votes
4 answers

pandas.read_html not support decimal comma

I was reading an xlm file using pandas.read_html and works almost perfect, the problem is that the file has commas as decimal separators instead of dots (the default in read_html). I could easily replace the commas by dots in one file, but i have…
Pablo
  • 3,135
  • 4
  • 27
  • 43
4
votes
2 answers

Evaluating a formula defined in another cell

Say I've got a function name in cell A1, like SUM, and some data in B1 and C1. Is there any way to define a formula in one cell such that it calls the formula that is defined in A1 and have it work on B1 and C1 as data? So something like: =A1(B1:C1)…
9a3eedi
  • 696
  • 2
  • 7
  • 18
3
votes
2 answers

Copy data from closed workbook based on variable user defined path

I have exhausted my search capabilities looking for a solution to this. Here is an outline of what I would like to do: User opens macro-enabled Excel file Immediate prompt displays for user to enter or select file path of desired workbooks. They…
user955289
  • 171
  • 2
  • 6
  • 19
3
votes
1 answer

Realm Database / App crashes in start up / call realm.init(context) before creating a realm configuration

I'm a newbie in Android and I'm trying to create a Realm database by watching tutorials. But my app doesn't start, it crashes. My main idea is the user finds nearby shops, by his location, select type of shop if he wants (restaurant, caffee etc) and…
Konstantinos Archimandritis
  • 187
  • 2
  • 11
3
votes
1 answer

What does the FORMULA.FILL function do in Excel 4 Macros?

I'm translating some functions written in Excel 4 XLM macros into VBA. One of the functions called within the macro I'm currently translating is FORMULA.FILL. I cannot seem to find any documentation of what this function does. Could anyone provide…
called2voyage
  • 252
  • 9
  • 28
3
votes
2 answers

Missing MSDN documentation to develop xll add ins?

I spent quite a lot of time in looking for the full documentation of all the C API XLM Functions without success. I found this page which illustrate a few of them: http://msdn.microsoft.com/en-us/library/office/bb687910%28v=office.12%29.aspx But for…
Marco
  • 319
  • 1
  • 5
  • 15
2
votes
2 answers

Grab formulas from closed Excel file (not just values)

I'm able to grab values from a closed workbook with the widely found GetValues function; it works great. But sometimes I need to grab the formula of a cell from the closed workbook. I tried modifying GetValues to grab the cells formula but I'm…
Stay-at-home-dad
  • 876
  • 3
  • 12
  • 27
1
vote
0 answers

Using data from API requests with text/XML format in R

I am a bit annoyed that the ENTSO-E only provides XML responses and no JSON formats for their API. Does anyone have experience with converting text/xml responses to dataframes in R? I usually use fromJSON(rawToChar(response$content)) from the…
Johannes Schwenzer
  • 41
  • 5
1
vote
1 answer

Googlesheets XML Import from Bank of Canada

I am trying to get specific exchange rates for a given interval from the Bank of Canada I am not very familiar with XLM importing but all the videos and examples on the internet seem to be very different compared to this) I am using something like…
mkelleci
  • 13
  • 3
1
vote
1 answer

How can I block or deactivate Excel 4.0 macros?

The only correct hint I found was in a screenshot of Excel settings (but these were in German). Is it at all possible to deactivate macros or macro sheets in Excel 4.0 or to always prevent them from being…
Mirko
  • 23
  • 6
1
vote
0 answers

Python: Minidom parseString not well-formed

I have and not well-formed error when trying to parser and string with minidom and ElementTree. In both cases happen when it closes the 2nd attribute (<\cause>) Here is my code from xml.dom import minidom import xml.etree.ElementTree as ET data =…
YarikMR
  • 11
  • 1
1
vote
0 answers

error received after loading Roberta and XLM_Roberta models from Huggingface

I am enjoying experimenting with different transformers from the excellent 'Huggingface' library. However, I receive the following error message when I attempt to use any kind of 'roberta'/ 'xlm' transformers. My Python code seems to work just fine…
Mark Padley
  • 51
  • 3
1
vote
1 answer

error flattening (convert to data.frame) XML file in R using xlm2 and xlmtools

I am trying to convert this xml_file (and many other similar ones) to a data.frame in R. Desired outcome: a data.frame (or tibble, data.table, etc) with: One row per Deputado (which is the main tag/level of xml_file, there are 4 of those) All…
LucasMation
  • 2,408
  • 2
  • 22
  • 45
1
vote
1 answer

Table columns not evenly spread out when created in the Java-file

I have a little piece of code which adds a new row (4 columns) to an existing table when pressing the btnTest-Button. Each field of this new row is filled with "0". However, the columns of the added rows are not evenly spread out (the columns are…
Kubi
  • 73
  • 6
1
vote
0 answers

XLSform for ODK - How do I change choices according to repetition?

Creating a form in XLSform for use with ODK I've run into a hitch with repetitions. The user is asked on the first repetition of a question group to select a "subplot". Data is entered and then the questions repeat. However, on the second repetition…
Oliver Burdekin
  • 1,098
  • 2
  • 17
  • 36
1
2 3