excel Questions
10
Solved
I have a .xls I need to convert to .csv
The file contains some date columns. The format on the date is "*14/03/2001" which, according to Excel means the date responds to regional date and time set...
Dressmaker asked 7/2, 2013 at 23:8
4
This is my VBA code to create a scatter plot in Excel:
Sub createmychart()
Dim Chart1 As Chart
Set Chart1 = Charts.Add
With Chart1
.SetSourceData Source:=Sheets("usd_download data").Range("A2:...
7
Solved
I have to get some random Excel sheets where I want to read only visible sheets from those files.
Consider one file at a time, let's say I have Mapping_Doc.xls which contains 2-visible sheets and ...
2
Solved
How can I reference a cell in the same column in the previous visible row from a filtered range?
Commodus asked 12/3, 2015 at 18:2
5
Solved
I have a VB Script that opens an Excel file and runs a macro. I am trying to close this excel file(without saving any changes) without being prompted to save. I have set the 'Saved' property to tru...
3
I have a problem in VBA with a line throwing back an error.
What the macro is intended to do is find a particular cell then paste data into it.
The code is as following:
'To find Column of Cust...
Stratify asked 15/12, 2013 at 23:13
5
Solved
I'm trying to write a function in Excel that will set the background color of the active cell according to the values stored in other three cells (each of those three cells store a numeric value fr...
9
Solved
I am using python to extract Arabic tweets from twitter and save it as a CSV file, but when I open the saved file in excel the Arabic language displays as symbols. However, inside python, notepad, ...
Bantam asked 15/2, 2020 at 13:13
4
Solved
I am a python pandas user but recently found about polars dataframe and it seems quite promising and blazingly fast. I am not able to find a way to open an excel file in polars. Polars is happily r...
Cosetta asked 28/3, 2022 at 4:23
4
Solved
I want to print an Excel file to a pdf file after manipulating it. For the manipulation I used the .xlsx package which works fine. There is a function printSetup but I cannot find a function to sta...
8
Solved
According to pandas doc for 0.21+, pandas.read_excel has a parameter sheet_name that allows specifying which sheet is read. But when I am trying to read the second sheet from an excel file, no matt...
6
I have several named columns on a sheet. I want to send the column number to a function that will return the column name.
For example, if column 1 is named "apple", I want to pass the column numbe...
5
I have a text file in this format :
{
attribute1 attribute2 attribute3.... attributeN
value"A" value"B" value"C".... value"Z"
/* next line of values*/
}
Each word is separated by a tab.
H...
Witchery asked 8/4, 2011 at 4:58
4
Solved
I am trying to write a huge excel file, my requirement allows me to write the row and forget, so i am using SXSSF which allows to keep only a few number of rows in memory and rest all are written t...
Stannite asked 13/12, 2013 at 8:0
7
Solved
I want to create a Sub that basically allows me to target an Excel table with a specific name and then insert a new row at the bottom and add data to that row at the same time. Then exit the sub. A...
9
Solved
Does anybody know if it is possible to show numbers in MS Excel with SI-prefixes?
I'd like to have
... 1 n, 1 µ, 1 m, 1, 1 k, 1M, 1 G, ...
instead of scientific format
... 1E-09, 1E-06, 1E-03...
Jernigan asked 24/9, 2013 at 21:5
6
Solved
Java 8 here using Apache POI 4.1 to load Excel (XLSX) files into memory, and write lists of Java beans/POJOs back to new Excel files.
To me, an Excel file (at least the ones I'm working with) is r...
Limbo asked 21/11, 2019 at 17:56
9
Solved
I have an Excel 2010 spreadsheet with links to external data sources including Bloomberg, 65 worksheets with VBA modules and references to other VBA add-ins.
The VBA project has acquired multiple W...
Sesqui asked 16/8, 2013 at 12:11
3
I need help with a tool I have created for my office team to monitor their effort utilization using Excel 2013 VBA Macro.
Unfortunately, the Macro could not find Add-Ins in anyone else's system tha...
Serriform asked 7/11, 2017 at 12:9
2
Solved
I have this simple formula in Cell A1
=10*Round(B1/10,0)
I know how to enter this in VBA, i simply write:
Range("A1").Formula = "=10*Round(B1/10,0)"
Now, what if I don't know ...
6
The Microsoft site suggests the following code should work:
Dim numbers = {{1, 2}, {3, 4}, {5, 6}}
However I get a complile error when I try to use it in an excel VBA module.
The following does w...
3
Solved
It is possible to get the calling workbook name Application.Caller.Worksheet.Parent.Name and cell address using Application.Caller.Address, for a function called in Excel.
Is there a way to get th...
4
I successfully parsed an xls file using Spreadsheet::ParseExcel::SaveParser and modified it with Spreadsheet::WriteExcel.
However working with xlsx file is a whole different thing.
I am trying to ...
7
Solved
How can I, without using formulas, show integers as integers, but decimals limited to a specific number of decimal places?
E.g. show:
1 as 1
12 as 12
but 1.23456789 as 1.23
The number format 0.## i...
Kv asked 24/4, 2018 at 17:29
4
Solved
In my research, I've found that there is no built in functionality for enabling double click events on Shapes on an excel sheet. Many of the workarounds I saw involved writing classes or other such...
© 2022 - 2024 — McMap. All rights reserved.