Alex Rivera | Logout

Questions tagged excel

385 questions · page 2 of 8

Sort by: Newest Votes Active
57
votes
5
answers

Substitute a comma with a line break in a cell

excel
asked 2013-02-13T15:04:33.320
20
votes
6
answers

Download excel file from page via WebApi call

c# asp.net excel asp.net-web-api xls
asked 2013-02-12T11:48:25.683
18
votes
1
answers

Terminating Macro From executing further on validation

vba excel
asked 2013-02-12T07:08:25.957
14
votes
6
answers

Run same excel macro on multiple excel files

vba excel
asked 2013-02-08T05:24:15.647
10
votes
2
answers

Office 2013 Excel .PutInClipboard is Different?

excel vba ms-office clipboard
asked 2013-02-06T20:38:19.333
9
votes
1
answers

Copy workbook containing macro to a workbook without macro

vba excel
asked 2013-01-29T13:20:38.300
10
votes
2
answers

How do I only count visible rows when using the COUNTIFS function?

excel excel-formula worksheet-function
asked 2013-01-14T17:09:51.287
74
votes
12
answers

Excel VBA code to copy a specific string to clipboard

excel clipboard vba
asked 2013-01-08T16:21:55.300
55
votes
4
answers

Remove #N/A in vlookup result

excel vlookup
asked 2013-01-07T20:09:58.773
17
votes
3
answers

Get Cell by a Cell reference letter identifier with Apache POI

java excel apache-poi
asked 2013-01-04T10:33:11.733
42
votes
4
answers

EXCEL VBA Check if entry is empty or not 'space'

excel vba space
asked 2013-01-01T08:15:17.137
24
votes
3
answers

Controlling Excel via Midi controller

excel vba midi winmm
asked 2012-12-30T22:27:40.083
8
votes
1
answers

How can I create product keys for VBA applications so that illegal distribution of software is prevented?

vba excel
asked 2012-12-21T04:20:58.773
10
votes
1
answers

How to get the column index of the current cell?

c# vb.net excel epplus
asked 2012-11-29T13:22:47.253
36
votes
9
answers

Excel to DataTable using EPPlus - excel locked for editing

c# excel epplus
asked 2012-11-15T11:29:06.023
18
votes
11
answers

export Excel to DataTable using NPOI

c# excel datatable npoi
asked 2012-11-11T17:09:49.193
69
votes
6
answers

excel plot against a date time x series

excel
asked 2012-11-10T06:31:47.333
41
votes
1
answers

How can I determine the character encoding of an excel file?

excel character-encoding
asked 2012-11-05T15:27:26.060
32
votes
8
answers

VBA enums give occasional "Constant Expression Required" errors

excel vba
asked 2012-11-02T14:12:28.973
8
votes
3
answers

Deleting all the data series in a dynamic chart

excel vba charts
asked 2012-10-17T18:56:23.810
11
votes
8
answers

Is it possible to fill an array with row numbers which match a certain criteria without looping?

arrays vba excel
asked 2012-10-16T18:41:55.013
94
votes
3
answers

Check if Cell value exists in Column, and then get the value of the NEXT Cell

excel
asked 2012-10-16T12:55:32.013
23
votes
7
answers

Using Apache POI how to read a specific excel column

java excel apache-poi
asked 2012-10-12T10:52:37.647
8
votes
1
answers

How to CountIf in multiple columns?

excel vba excel-formula
asked 2012-10-12T09:30:18.257
29
votes
4
answers

vba code refactoring - are there any tools to assist?

vba excel
asked 2012-10-04T10:23:38.557
12
votes
3
answers

programmatically excel cells to be auto fit width & height

c# excel office-interop
asked 2012-10-03T14:56:28.823
19
votes
7
answers

Reading excel files with xlrd

python excel xlrd
asked 2012-10-03T09:26:47.820
10
votes
1
answers

Is there an auto complete shortcut in VBA?

excel vba
asked 2012-10-02T12:37:15.217
9
votes
3
answers

Get cell index from cell value, Apache POI

java excel apache-poi
asked 2012-09-26T18:58:05.497
8
votes
2
answers

Changing color of tabs in Excel using VBA?

excel vba
asked 2012-09-17T17:38:32.943
25
votes
4
answers

VBA code to set date format for a specific column as "yyyy-mm-dd"

excel vba
asked 2012-09-07T19:24:24.997
8
votes
3
answers

reasons why excel.exe remains loaded after running a delphi client automation program?

excel delphi office-automation
asked 2012-09-06T16:27:48.510
73
votes
13
answers

How to obtain sheet names from XLS files without loading the whole file?

python excel pandas xlrd
asked 2012-09-03T14:44:51.630
28
votes
5
answers

Selectable Text in VBA Message Box

vba user-interface excel
asked 2012-08-30T01:35:48.607
12
votes
1
answers

Run-time error '1004' : Method 'Range' of object'_Global' failed

excel vba
asked 2012-08-29T09:26:41.177
11
votes
3
answers

Get Excel sheet into temp table using a script

sql sql-server sql-server-2008 excel
asked 2012-08-23T11:29:01.983
11
votes
7
answers

How do I use checkboxes in an IF-THEN statement in Excel VBA 2010?

vba excel excel-2010
asked 2012-08-16T16:07:55.100
13
votes
2
answers

how to get a 'Cell' object in excel VBA

excel vba
asked 2012-08-13T21:13:31.603
9
votes
10
answers

Remove duplicates from array using VBA

excel vba
asked 2012-08-08T17:39:38.410
11
votes
2
answers

Opening different tabs of same workbook in different windows in Excel 2010

excel excel-2010
asked 2012-08-03T17:52:56.433
19
votes
3
answers

How to copy a line in excel using a specific word and pasting to another excel sheet?

excel vba
asked 2012-07-24T12:58:01.277
11
votes
1
answers

How to detect if a cell is empty when reading Excel files using the xlrd library?

python excel xlrd
asked 2012-07-22T18:43:18.940
70
votes
5
answers

Setting Column width in Apache POI

excel apache-poi
asked 2012-07-20T06:33:27.370
16
votes
5
answers

EPPlus Error When Outputting .XLSX to Response

c# asp.net excel epplus
asked 2012-07-18T19:47:27.247
17
votes
1
answers

What is the VBA code to emulate selecting a block with the CTRL+A shortcut?

excel range excel-2010 vba
asked 2012-07-18T12:53:04.947
40
votes
9
answers

Cell Style Alignment on a Range

c# excel format alignment
asked 2012-07-17T19:52:01.293
8
votes
2
answers

Inserting new rows and moving existing ones with OpenXML SDK 2.0

c# asp.net excel openxml openxml-sdk
asked 2012-07-12T14:06:31.247
13
votes
2
answers

Getting error Procedure too large in VBA Macros (Excel)

vba excel excel-2003
asked 2012-07-12T10:49:44.253
17
votes
9
answers

fputcsv and integer typcasting to string

php excel csv fputcsv
asked 2012-07-10T18:10:37.907
11
votes
1
answers

Coloring complete Row based on values from Columns

vba excel excel-formula
asked 2012-07-01T08:31:26.937
← Prev page 2 of 8 Next →