Stack Overflow
Stack Overflow

Questions tagged [xlsm]

.xlsm is one of the file extensions for files created by Microsoft Excel (Excel 2007 or later). This format can store macros written in VBA.

Starting from Excel version 2007, Microsoft changed the format of the Microsoft Office files.

Formerly, Microsoft used the BIFF (Binary Interchange File Format) binary format (.xls, .doc, .ppt). It now uses the OOXML (Office Open XML) format. These files (.xlsx, .xlsm, .docx, .docm, .pptx, .pptm) are zipped-XML.

.xlsx is the new default Excel format, it cannot contain any VBA (for security reasons as stated by Microsoft).
.xlsm is the new Excel format that can store VBA and execute macros.

270 questions
1
vote
1 answer

Converting XLSM file to CSV format in Perl using "$csv->print" function?

Does function CSV->PRINT only accept array reference? I am pushing $cell2_value in an array and then printing the array (i.e rows), it would be nice if I can directly write $cell2_value into an opened CSV file. Things to take care of - Excel cell…
himmat
  • 159
  • 5
1
vote
1 answer

Turning PDF Macro into Excel

I am trying to convert this code that instead of saving PDF copies it saves the individual sheets as Excel workbooks instead. I have tried changing the Export as fixed format to xlsm but it appears to have a run time error. Very new to this but any…
Jack Staniforth
  • 13
  • 3
1
vote
0 answers

How to write/modify specific sheet from XLSM file using R Shiny without altering other existing sheets in the file

I've been creating a R Shiny application in which I need to write/modify a sheet from Macro Enabled Excel file (.XLSM) using R. I came up through three packages that deals with this problem: xlsx, openxlsx, XLConnect. With openxlsx package, I'm able…
Shashi Bharti
  • 53
  • 2
  • 6
1
vote
2 answers

Read and write XLSM file in PHP

I want to read and write XLSM type file using PHP. I tried using PHPSpreadsheet for this but it doesn't support XLSM extension. One possible solution could be to use EasyXLS…
Amarjeet Pati
  • 21
  • 1
  • 2
1
vote
1 answer

User to import XLSM files into Oracle APEX

Is there a way where the user can import XLSM (macro) files? I'm building an application and the user would have to import their files which are Excel with macros. For this application I would only need certain data from these files, like columns…
Solera
  • 23
  • 4
1
vote
1 answer

Convert Rows to Columns with values in Excel using custom format

I having a Excel sheet with 1 Merged cell column and 3 subcolumns in that.So I want custom sort the columns and rows on the basis of my format. I have tried using index like this =INDEX(Full!$A$1:$AH$579,COLUMN(A1),ROW(A1)) but this not working in…
ssd
  • 45
  • 6
1
vote
1 answer

From VBA to Python and back again to Excel

I am trying to make an automated program using Excel and Python 3.7.1. Starting from an Excel sheet, the user is supposed to click a button which is been assigned a Macro (actually it is an ActiveX Controls Command Button). This Macro runs Python…
CarlIO
  • 111
  • 2
1
vote
2 answers

How to fix "We found a problem with some content in 'abc.xlsm'. Do you want us to try to recover as much as we can?

I have the following method (createAdditionalSheetsInExcel) in my code which tries to create additional sheets for a particular scenario (runOutputNumber > 1). It ends up creating an excel but the problem is when you try to open the excel you end up…
Sai Haridass
  • 344
  • 2
  • 11
1
vote
1 answer

How to improve openpyxl writing values in cells?

I have a template .xlsm file with macros and a basic structure. I need to write inside the file some user object that I have in an array. Since there are many columns that aren't used (or don't have a value corresponding in the user class), I need…
Claudio
  • 123
  • 3
  • 15
1
vote
0 answers

Content cannot be enabled for .xlsm file generated with PhpExcel

I am trying to load and write contents on already existing .xlsm templates and save it as a new file in different directory.These files has macros ad the macros needs to be protected as it were in the original file. I have done the following things…
Tekraj Shrestha
  • 1,228
  • 3
  • 20
  • 48
1
vote
1 answer

Dialog box opens when quitting XLSM, DisplayAlerts does not work

When the application closes, the display pops up if I want to save the file. I don't want to save the file and want it to automatically close. I thought DisplayAlerts = False would do the job, but it won't work if os.path.exists("file_name.xlsm"): …
Bart
  • 11
  • 1
1
vote
1 answer

Python: Write Data to Columns in Protected .xlsm Excel File

I have a password-protected .xlsm file with formulas in some columns and macros. Is there a way for me to write data from pandas into specific columns in this .xlsm file? I have tried xlwings, but it takes 15 minutes to update 10k rows, even with…
SAKURA
  • 937
  • 11
  • 29
1
vote
1 answer

XLSB Personal Macro file Variable Error

Disclaimer: This is not my code. I took a macro from a regular xlsm file and placed it on a xslb file to have it handy for analysis. The macro works correctly in the xlsm, but encounters a variable issue on the xlsb file. ColumnToFormat identifies a…
Nahuatl_C137
  • 132
  • 1
  • 13
1
vote
1 answer

Worksheet_SelectionChange not working for XLSM worksheet

I am trying to capture a click event in a cell by editing the VBA code in one of my xlsm worksheets. For a sanity check, I am merely trying to turn whatever cell is clicked red. Here is my VBA code Private Sub Worksheet_SelectionChange(ByVal Target…
TJB
  • 3,706
  • 9
  • 51
  • 102
1
vote
0 answers

How to parse a specific tab information using XssFReader in EventModel using POI

I am working with a large xlsm file, the file has many tabs and i want to parse a specific tab information.I am able to load the file using apache EventUsrerModel documentaion.But i am not able to get the specific tab information using XSSFReader…
Mandrek
  • 1,159
  • 6
  • 25
  • 55
1 2 3
…
17 18