excel Questions
1
When I save my Excel file with VBA, it asks me to enter my credentials (it saves it on some kind of server). Looking though the website I found a way to use SendKeys and delay the action.
My issue:...
4
Solved
I'm trying to write a text formed with Ascii Art.For example "Hi".It's hard for me, so I'm here asking your help.Here is what I'm do till now:
Option Explicit
' I tried with a Type.
Priv...
10
Solved
So I've asked a similar question, but I thought I'd ask it more generally to get as many ideas as possible.
I have Power BI Pro. I am tasked with creating reports for hundreds of recipients, each ...
3
Solved
I've got an filetime value, for example: 122327856000000000
and want to convert it to an excel date (1988-aug-23)
6
Solved
I would like to aggregate, merge, compact some values as shown below
The input is a table and the output is dynamic array formulas on a single Cell and has a goal to aggregate other columns based o...
Petula asked 14/9 at 15:51
4
I have some data in an excel file and I read it using pandas read_excel method.
However I want to read the entire data in all columns as strings including the date column.
The problem is that I w...
2
Solved
I have a Cell object, how can I get the name of that cell?
Would like a function such as:
String name = myCell.getName();
In Excel I have named it in the name box, so I don't want to get 'B4',...
Babettebabeuf asked 30/10, 2014 at 9:43
0
How could the below code be modified to create 3 columns such that column A contains unique HEX codes representing text colors (each cell in column A would contain the HEX code displayed in the res...
Chin asked 8/9 at 17:40
6
Solved
I am now using PyExcelerator for reading excel files, but it is extremely slow. As I always need to open excel files more than 100MB, it takes me more than twenty minutes to only load one file.
Th...
2
Solved
NotOLE2FileException: Invalid header signature; read 0x0000000000000000, expected 0xE11AB1A1E011CFD0
What I want to do is ask the user if they want to create a new or select an existing Excel workbook. Selecting an existing file is no problem. However I get an error saying "Your file appears not t...
Author asked 23/11, 2015 at 19:54
2
Solved
I would like to get a range of the first column from a larger range. For example:
If the range is $E$9:$I$259, the result should be $E$9:$E259
How can I achieve this?
3
Solved
Is there any way to check in VBA if a specific column of a table (ListObject) in Excel is a calculated column (as in https://support.microsoft.com/en-us/office/use-calculated-columns-in-an-excel-ta...
Puree asked 9/1, 2013 at 16:54
2
Solved
OK so, I know I can do this:
Dim ws as worksheet
Set ws = thisworkbook.worksheets("Sheet1")
and then do my fancy stuff with the ws worksheet object
I also know I can Dim wss as worksheets and t...
2
I have a set of linked subs which work like this:
A user types into an ActiveX TextBox
A Change Event in that TextBox calls a sub in a Module
That Module sub drives updating a named range in a s...
5
I am using the new dynamic array functions introduced in Excel in 2018 (e.g. SEQUENCE, UNIQUE etc. functions).
I have a list of cell references that are generated dynamically and would like to appl...
Hawse asked 23/10, 2020 at 19:4
6
I am new to Python.
I use putty to manage some servers. I want to use Python to create a Excel file on each server, for that I think if I can use some orders like ssh ip "python abc.py" to create ...
3
Solved
I have to update a spreadsheet that looks like this.
It's not hard at all. I just go to the last line and enter what I need in the appropriate columns. I'd like to automate this. The first thing...
Verner asked 10/6, 2016 at 21:52
2
I have this code in VBA that needs to be in Python. I'm new to Python, sorry for that.
Sub cdec_test()
Dim val1, val2, result1, result2, x1, x2 As Variant
val = CDec(5930 / 3000) 'val1 : 1.97666666...
3
Solved
First I have last update file from DB
DataTable excelData = ReadSCOOmega(lastUploadFile);
, after this iterate over this data
foreach (DataRow currentRow in rows)
{
currentRow.
}
Is that pos...
8
Solved
Maybe i am just not that good enough in math, but I am having a problem in converting a number into pure alphabetical Bijective Hexavigesimal just like how Microsoft Excel/OpenOffice Calc do it.
H...
Plast asked 22/12, 2011 at 11:50
4
Solved
I am using ClosedXML to generate spreadsheets from C# (asp.net-mvc) and it works great. I have one additional requirement so I wanted to get some feedback on how I could achieve this.
I want to sa...
Kinata asked 1/4, 2014 at 13:6
2
Solved
I was just curious if there might be a way to call functions dynamically. For example.
Sub foo1()
Debug.Print "in foo1"
End Sub
Sub foo2()
Debug.Print "in foo2"
End Sub
Is there a way that I...
3
Solved
I have a somewhat large .xlsx file - 19 columns, 5185 rows. I want to open the file, read all the values in one column, do some stuff to those values, and then create a new column in the same workb...
10
Solved
Access is truncating the data in a couple Memo fields when I am appending an Excel file. The field in the Access table is already set as a Memo type. I believe the problem is that I do not have any...
Hemimorphite asked 6/3, 2013 at 14:20
3
Solved
Suppose there is an empty excel sheet. Enter formula "=A1" into the B1 cell. The value of B1 would be 0.
My question is: why the value of B1 becomes zero when referring to an empty cell A1? Any ra...
Olives asked 3/4, 2017 at 17:55
1 Next >
© 2022 - 2024 — McMap. All rights reserved.