excel Questions
3
Solved
Is there a way to figure out when the user has made changes to the sheets filter?
In other words is there a change_filter event handler of some sort?
22
I am attempting to create a chart with a dynamic data series. Each series in the chart comes from an absolute range, but only a certain amount of that range may have data, and the rest will be #N/A...
Radicel asked 21/2, 2013 at 23:2
7
Thanks to pandas, we could read a whole sheet into a data frame with the "read_excel" function.
I would like to use the same method using xlwings. In fact, my Workbook is already open and...
9
Solved
I am writing a VBA code that goes through a range of cells checking if each cell has data validation (drop down menu) and if not assign one to it from a list on another sheet.
I currently have tro...
Paraphrast asked 5/9, 2013 at 17:55
4
What is the default measurement unit of Excel cell size? Is it Point or Pixel or Millimeter ?
By default, excel cell Row height is 15, what is the meaning of this value? Is it 15 Pixels or 15 Poin...
4
Solved
I'm trying to teach myself VBA during the short holiday break.
For my first module, I want to create a module that does the following:
Displays dialog box. Prompts user to select CSV files.
Open ...
10
Solved
I am designing an Excel worksheet where the user will click a command button which copies a predetermined range of cells. The user would then paste the contents into a web app using Firefox or IE. ...
Trustworthy asked 19/9, 2013 at 20:1
7
I keep getting this error when I load my spreadsheet. It makes me repair it, which strips all the validators. The file is saved as an xlsm.
"Excel found unreadable content in '' Do you wnat to rec...
9
Solved
In my app, I write to an excel file. After writing, the user is able to view the file by opening it. But if the user forgets to close the file before any further writing, a warning message should a...
4
Solved
I have quite a complex SSRS report that I would like to export to Excel more or less how it looks in the web output.
Export to Excel and opening in Excel 2010 yields the following error:
Excel ...
Hoelscher asked 7/5, 2014 at 5:12
7
Solved
I have a moderately large xlsx file (around 14 MB) and OpenOffice hangs trying to open it. I was trying to use openpyxl to read the content, following this tutorial. The code snippet is as follows:...
5
Sorry if this has been asked before but I can't find it. I am looking for an authoritative description of all valid strings that can be used as a reference, e.g., "A1:C5", "$A:$A", $A2" etc etc. Th...
Deplane asked 4/6, 2010 at 21:28
2
Solved
I've got a column of ages and a column of the count of those ages. I need these to be transformed into a set that I can run statistical functions like average on. For example:
Age
Count
14
...
Kovno asked 20/10, 2023 at 15:21
14
Solved
I have the following javascript code that convert date (string) to the Date Serial Number used in Microsoft Excel:
function JSDateToExcelDate(inDate) {
var returnDateTime = 25569.0 + ((inDate.ge...
Divaricate asked 26/4, 2013 at 5:43
6
I'm trying to generate a random 8 character alphanumeric string in Excel (or Google Sheets or Libreoffice, which both have the same challenge) using a formula. I'd like to get something like this:
...
Prae asked 5/12, 2022 at 21:57
1
I am trying to run a function in Excel from a dll made via C++.
I have followed the steps in the Microsoft DLL creation overview and successfully gotten the DLL/client example working. I've also fo...
Aluminothermy asked 23/12, 2020 at 4:27
5
I'm using the GROWTH (or LINEST or TREND or LOGEST, all make the same trouble) function in Excel 2003. But there is a problem that if some data is missing, the function refuses to give result:
You...
Monger asked 31/1, 2013 at 9:49
10
Solved
I'm stumped in Excel (version 16.0, Office 365). I have some cells that are formatted as Number, all with values > 0, but when I use the standard SUM() on them, it always shows a result of 0.0 inst...
Wafture asked 16/5, 2020 at 14:1
7
Solved
I have a report I am doing with SSRS 2008 with some rows that have multiple elements inside them. On the preview the row automatically expands to support the extra elements but however when I expor...
Duley asked 22/8, 2014 at 9:30
20
Solved
Is there any easy/short way to get the worksheet object of the new sheet you get when you copy a worksheet?
ActiveWorkbook.Sheets("Sheet1").Copy after:=someSheet
It turns out that the .C...
4
Solved
I'm trying to open an excel file using a button click. And for some reason it's not working. I've tried several things. Any ideas why they are not working?
Method 1 I have tried. This opens the fi...
23
What is the fastest c# function that takes and int and returns a string containing a letter or letters for use in an Excel function? For example, 1 returns "A", 26 returns "Z", 27 returns "AA", etc...
Figment asked 7/5, 2009 at 21:35
7
Solved
Without VBA, I am trying to refer a range that starts at A2 and never ends. For example, if I want row 2 till row 5 i'd do
$A$2:$A$5
But what if I want the end to be open?
$A$2:??
Is this po...
Aemia asked 6/10, 2017 at 8:56
3
Solved
I have a requirement Where I need to add data validation to an entire column rather than a specific cell. I went through the documentation of Apache poi and found the example below
HSSFWorkbook wo...
Weimer asked 27/1, 2015 at 15:17
2
Solved
In Excel (2007) VBA how do I print the worksheet to a specific printer tray? This will just print to the default tray on the printer:
ws.PrintOut ActivePrinter:="\\print_server\printer_name"
© 2022 - 2024 — McMap. All rights reserved.