Questions tagged [excel]

12

votes

2

answers

VBA split string by spaces

asked 2013-08-01T11:56:07.043

45

votes

5

answers

How to extract sheet names from Excel file in R

r excel xlconnect

asked 2013-07-30T10:39:29.290

8

votes

6

answers

Sum visible (or filtered) range in an Excel Spreadsheet

excel vba

asked 2013-07-24T13:21:23.753

15

votes

3

answers

How to delete Certain Characters in a excel 2010 cell

excel character excel-2010 cell

asked 2013-07-15T10:43:29.190

37

votes

7

answers

Delete entire row if cell contains the string X

excel vba excel-2010 excel-2007

asked 2013-07-12T01:10:36.857

24

votes

3

answers

How to save Excel Workbook to Desktop regardless of user?

excel vba

asked 2013-07-09T14:44:38.230

13

votes

2

answers

Run Time Error 1004 'Unable to get the PivotFields property of the PivotTable class'

vba excel range runtime-error

asked 2013-07-02T15:35:28.833

20

votes

3

answers

Excel VBA Open a Folder

vba excel directory excel-2010

asked 2013-07-02T13:18:57.797

8

votes

7

answers

Fast method for determining unlocked cell range

excel vba

asked 2013-06-30T05:24:50.187

21

votes

15

answers

Insert row into Excel spreadsheet using openpyxl in Python

python excel xlrd xlwt openpyxl

asked 2013-06-25T14:00:19.800

19

votes

2

answers

What's the RIGHT way to reference named cells in Excel 2013 VBA? (I know I'm messing this up)

vba excel excel-2013

asked 2013-06-21T05:33:50.427

19

votes

2

answers

VBA: How to delete filtered rows in Excel?

vba excel excel-2007

asked 2013-06-19T14:49:14.623

17

votes

2

answers

How to set color or background with "excelpackage"

c# excel excelpackage

asked 2013-06-17T20:19:54.410

8

votes

2

answers

VBA Stop calculation of cells

excel vba

asked 2013-06-06T12:54:54.767

11

votes

4

answers

Simple Example of VSTO Excel using a worksheet as a datasource

c# visual-studio-2010 excel vsto excel-2010

asked 2013-06-04T19:49:37.107

107

votes

2

answers

The quest for the Excel custom function tooltip

c# excel .net-4.0 office-interop decompiling

asked 2013-06-03T18:41:05.700

11

votes

4

answers

"Cannot insert object" error when adding ActiveX control like Microsoft DataGrid to Excel sheet

excel security activex

asked 2013-06-03T09:15:54.300

8

votes

3

answers

using COUNTIF with blank value criteria with variable ranges

excel excel-formula

asked 2013-05-31T13:53:17.117

11

votes

4

answers

Use formula in custom calculated field in Pivot Table

excel excel-2010 pivot-table

asked 2013-05-20T20:00:10.367

46

votes

6

answers

XlsxWriter object save as http response to create download in Django

python django excel httpresponse xlsxwriter

asked 2013-05-06T06:35:46.890

14

votes

3

answers

How do I create URLs in Excel based on data in another cell?

excel excel-2007 excel-formula

asked 2013-05-03T14:43:26.660

56

votes

10

answers

VBA check if file exists

excel vba file exists file-exists

asked 2013-05-03T03:43:38.483

15

votes

3

answers

How do I count cells that are between two numbers in Excel?

excel range formula

asked 2013-05-02T18:04:14.717

16

votes

3

answers

Removing gridlines from excel using python (openpyxl)

python excel python-2.7 openpyxl

asked 2013-05-02T16:14:16.470

10

votes

4

answers

Get values from last 3 non-blank cells in a row

vba excel worksheet-function

asked 2013-04-28T11:15:09.397

26

votes

2

answers

Using Excel VBA to export data to MS Access table

sql excel ms-access vba

asked 2013-04-23T05:47:09.510

14

votes

2

answers

Generating 2D (PDF417 or QR) barcodes using Excel VBA

excel vba fonts barcode

asked 2013-04-22T09:12:01.997

16

votes

3

answers

How do I issue an HTTP GET from Excel VBA for Mac

excel vba macos http-get

asked 2013-04-12T22:38:04.960

9

votes

9

answers

Concatenate multiple ranges using vba

excel vba concatenation

asked 2013-04-08T20:28:14.903

17

votes

11

answers

Data import from Excel to SQL Server failing to import all data

sql-server excel import

asked 2013-04-08T17:06:43.423

13

votes

3

answers

Using Excel as an ODBC database

database windows excel ms-access odbc

asked 2013-04-05T22:25:21.333

25

votes

5

answers

How to remove all non alphanumeric characters from a string except period and space in excel?

excel vba

asked 2013-03-30T21:26:28.883

24

votes

4

answers

Set a cell value from a function

vba excel

asked 2013-03-27T13:15:38.877

11

votes

2

answers

How to change the specific text color in a same cell of excel sheet using apache poi?

java excel apache-poi

asked 2013-03-17T02:13:11.833

8

votes

4

answers

System.ArgumentException: Illegal characters in path. error

c# excel

asked 2013-03-12T18:12:21.777

9

votes

2

answers

EPPlus - Working with multiple columns by index rather than Alphabetical Representation

c# vb.net excel epplus

asked 2013-03-12T17:50:37.817

12

votes

1

answers

Copying an image - Excel VBA

excel vba copy image

asked 2013-03-11T18:17:50.357

8

votes

1

answers

VBA: Else without If Error

vba excel

asked 2013-03-06T15:48:29.740

27

votes

1

answers

R Download.File Issue with Excel Workbook

r excel download

asked 2013-03-06T14:42:10.780

12

votes

15

answers

Have Excel formulas that return 0, make the result blank

excel worksheet-function

asked 2013-03-06T05:13:38.167

20

votes

2

answers

MD5 Hash function in excel without using VBA

excel excel-formula md5

asked 2013-03-04T12:11:31.457

13

votes

1

answers

Excel - How can I make a scatter plot which colors by a third column?

excel sorting

asked 2013-02-27T22:52:31.793

9

votes

8

answers

Javascript IRR (Internal rate of return) Formula Accuracy

javascript jquery excel math excel-formula

asked 2013-02-26T12:28:34.600

15

votes

2

answers

Count only fields with text/data, not formulas

excel count

asked 2013-02-25T21:53:10.043

57

votes

22

answers

Creating a chart in Excel that ignores #N/A or blank cells

excel

asked 2013-02-21T23:02:40.677

96

votes

4

answers

What is the better API to Reading Excel sheets in java - JXL or Apache POI

java excel apache-poi jxl

asked 2013-02-20T13:12:26.987

8

votes

2

answers

Is there a VBA command that causes a debug to start at that point?

vba excel

asked 2013-02-20T10:19:13.823

12

votes

10

answers

Ordering issue with date values when creating pivot tables

excel date formatting pivot-table

asked 2013-02-19T15:56:13.137

37

votes

4

answers

How to find a value in an excel column by vba code Cells.Find

vba excel

asked 2013-02-18T07:58:36.087

9

votes

3

answers

Is the Excel 2013 plugin API backwards compatible with Excel 2003-2010?

c# visual-studio excel ms-office

asked 2013-02-14T17:34:47.793

Questions tagged excel