Questions tagged [excel]

8

votes

3

answers

I don't want my Excel Add-In to return an array (instead I need a UDF to change other cells)

asked 2011-12-15T13:17:40.887

12

votes

1

answers

Excel Error 406 when using both VBA and ActiveX addins.

c# excel excel-addins activex-exe vba

asked 2011-12-14T21:31:21.927

11

votes

3

answers

Make column read-only using apache poi

java excel apache-poi

asked 2011-12-14T09:58:59.457

11

votes

4

answers

Writing to excel files in ruby using roo gem

ruby ruby-on-rails-3 excel spreadsheet

asked 2011-12-13T17:46:39.113

43

votes

5

answers

Saving openpyxl file via text and filestream

python excel filestream openpyxl

asked 2011-12-12T03:32:51.623

17

votes

5

answers

How to define a non continuous range in COUNTIF

excel formula

asked 2011-12-07T19:18:07.980

11

votes

2

answers

Is it good practice to leave "Debug.Print" instructions in code that goes in "production"?

excel vba

asked 2011-12-07T08:41:18.193

18

votes

4

answers

how to get EPPlus OpenXML row count (c#)

c# asp.net excel io epplus

asked 2011-12-06T13:01:38.773

8

votes

1

answers

Exporting a ListView to Excel format

c# excel listview export-to-excel

asked 2011-11-29T14:17:11.907

8

votes

2

answers

Excel VBA Regex Match Position

regex excel vba

asked 2011-11-28T20:03:08.137

11

votes

6

answers

How do i determine if an error is in any cell in the entire workbook with Excel VBA

excel vba

asked 2011-11-22T17:00:06.100

19

votes

6

answers

Loading CSV files into MySQL Workbench

mysql excel csv mysql-workbench

asked 2011-11-15T21:04:01.040

84

votes

10

answers

How to merge rows in a column into one cell in excel?

excel vba

asked 2011-11-15T11:57:56.477

44

votes

3

answers

Excel VBA, getting range from an inactive sheet

excel vba

asked 2011-11-08T08:55:07.047

10

votes

5

answers

Deleting Empty rows in Excel using VBA

excel vba

asked 2011-10-24T13:28:50.667

25

votes

2

answers

Language independent way to get "My Documents" folder in VBA Excel 2003

excel vba excel-2003

asked 2011-10-13T08:39:58.667

11

votes

3

answers

Is there any way I can speed up this VBA algorithm?

vba excel trie

asked 2011-10-07T21:09:45.703

33

votes

11

answers

Programmatically getting the last filled excel row using C#

c# excel

asked 2011-10-06T13:00:53.797

10

votes

4

answers

How to delete rows in Excel based on criteria using VBA?

excel vba

asked 2011-10-04T13:29:02.090

25

votes

10

answers

Getting the actual usedrange

excel vba

asked 2011-09-14T21:09:29.793

33

votes

3

answers

How to loop through Excel files and load them into a database using SSIS package?

excel ssis

asked 2011-09-14T05:39:41.007

13

votes

4

answers

Excel VBA call function with variable name

excel vba

asked 2011-09-13T18:16:25.197

31

votes

6

answers

Export SQL query data to Excel

sql sql-server excel export-to-excel

asked 2011-09-12T14:41:59.363

11

votes

4

answers

Python clean way to wrap individual statements in a try except block

python excel vba com try-catch

asked 2011-09-01T13:45:49.020

23

votes

10

answers

How to find numbers from a string?

string vba excel

asked 2011-08-30T06:10:49.680

15

votes

1

answers

Get Excel sheet name and use as variable in macro

excel vba

asked 2011-08-24T13:43:26.330

60

votes

10

answers

Microsoft Office Excel cannot access the file 'c:\inetpub\wwwroot\Timesheet\App_Data\Template.xlsx'

c# excel export-to-excel excel-interop

asked 2011-08-18T11:04:41.923

10

votes

4

answers

Excel trailing comma bug in csv files

excel vba debugging csv

asked 2011-08-16T13:34:14.427

23

votes

3

answers

How to get combobox not to accept user input in Excel-Vba?

excel vba controls excel-2007

asked 2011-08-10T06:49:03.527

10

votes

3

answers

R: Reversing the data in a time series object

excel r reverse time-series

asked 2011-08-07T18:00:26.487

25

votes

12

answers

How does Excel successfully round floating point numbers even though they are imprecise?

c++ excel math floating-point rounding

asked 2011-08-03T17:43:47.300

9

votes

1

answers

How do I save images from Excel without using Clipboard, in C#?

c# image excel export

asked 2011-07-26T20:58:52.637

28

votes

6

answers

Lock down Microsoft Excel macro

excel vba security

asked 2011-07-20T11:11:13.937

16

votes

4

answers

Help needed with Median If in Excel

excel function if-statement median

asked 2011-07-19T19:09:48.050

10

votes

3

answers

Execute external program in ruby and wait for its execution

ruby excel external

asked 2011-07-11T11:36:14.630

156

votes

16

answers

Which encoding opens CSV files correctly with Excel on both Mac and Windows?

windows excel macos csv utf

asked 2011-07-05T19:50:17.407

10

votes

3

answers

How to find and unhide a hidden module in VBA

vba excel

asked 2011-07-04T01:15:32.370

32

votes

5

answers

Worksheet get_Range throws exception

c# excel

asked 2011-07-01T10:31:38.870

9

votes

3

answers

Generating a tree in Excel

excel graph tree charts

asked 2011-07-01T05:31:47.647

12

votes

4

answers

In Excel, how to round to nearest fibonacci number

excel rounding worksheet-function fibonacci

asked 2011-06-28T15:47:27.053

15

votes

3

answers

Excel is calculating a formula with a VBA function as an error unless it is re-entered

excel vba user-defined-functions

asked 2011-06-24T15:41:44.097

11

votes

6

answers

How to read an excel file contents on client side?

javascript excel jsp

asked 2011-06-17T07:19:27.670

16

votes

4

answers

python win32 COM closing excel workbook

python winapi excel com win32com

asked 2011-06-13T23:35:18.353

17

votes

3

answers

Include formatting information in windows clipboard copy buffer for pasting into Excel

windows excel copy clipboard paste

asked 2011-06-09T21:59:33.227

13

votes

1

answers

XLL Excel addin in unmanaged C++

c++ excel add-in xll

asked 2011-06-09T10:00:23.123

32

votes

3

answers

excel vba call subroutine with variables

excel vba subroutine

asked 2011-06-06T12:52:09.490

13

votes

3

answers

Excel Get_Range with multiple areas

c# excel excel-interop

asked 2011-05-27T16:31:50.117

12

votes

2

answers

Excel Date Field Import Problem in Oracle SQL Developer

sql oracle-database excel timestamp oracle-sqldeveloper

asked 2011-05-20T02:07:02.967

15

votes

2

answers

How to set "AutoSize" to Excel sheet column? (NPOI)

c# .net excel npoi

asked 2011-05-19T07:55:51.650

13

votes

2

answers

Finding the English definition of a word in VBA

excel vba

asked 2011-05-12T16:51:03.733

Questions tagged excel