Stack Overflow
Stack Overflow

Questions tagged [excel-2007]

The Excel-2007 tag is used for referencing the Excel Version 2007 spreadsheet application from Microsoft. The version independent Tag is "excel". If your question is about VBA then also tag it VBA. If it is about an Excel formula or worksheet function, then tag it worksheet-function.

Excel 2007 is the 12th version of Microsoft's commercial spreadsheet program. It is the first version of Excel to incorporate a new user interface (UI), which is now standard across most/all Office suite programs.

This tag is used for questions specific to the 2007 version of the program. However, it is usually used in tandem with other tags, to let SO users know what your question is about. If your question is about VBA then also tag it . If it is about an Excel formula, tag it or . Questions about addins for Excel 2007 should be tagged .

Links:

3668 questions
9
votes
1 answer

How to "format as table" in Excel or apache POI?

In Excel 2010 it's possible to "format as table" a group of cells - enabling easy sorting and filtering (Home > Format As Table). Can I do the same in Apache POI? Alternatively, can one accomplish the above directly in Excel via a macro/formula (as…
Nikita
  • 6,019
  • 8
  • 45
  • 54
9
votes
4 answers

Upload Excel file and extract data - asp.net mvc 3

I am wondering how do I extract data out of a 2007 excel file? I am using asp.net mvc 3. My plan is to have a upload section that you choose a file and hit upload. I have no clue after that what kind of format it will be or what I need to do to…
chobo2
  • 83,322
  • 195
  • 530
  • 832
9
votes
8 answers

read .xlsx without Excel and OLEDB

Is there any chance to read .xlsx files in C# without having Excel installed on the client, and with no OLEDB connection available? The application is a Winforms project written in VS2005 C# .NET Framework 2.0.
Sunlog
  • 269
  • 1
  • 3
  • 13
9
votes
2 answers

How to permanently allow macro for a trusted worksheet?

I've created a worksheet which is shared amongst my colleagues with a real simply macro to show/hide rows but everytime either I or one of my colleagues opens it they get prompted to Allow marco - is there anyway for them to permantly allow this…
experimenter
  • 768
  • 1
  • 9
  • 30
9
votes
7 answers

writing to excel in java

Can someone point me in the right direction for writing to an excel file in java?? I am not understanding the links I found online. Could you just send me a link or anything which I could follow through?? Thank you, J
JJunior
  • 2,831
  • 16
  • 56
  • 66
9
votes
1 answer

Using Excel sheet as a template vs. a "real" Excel template in OpenXML

Does anyone have any good answer what kind of difference there is between using some arbitrary pre-formatted Excel 2007 *.xlsx file as a template, loading it in my C# app, and filling up some of its cells with data using the Microsoft OpenXML SDK…
marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
9
votes
1 answer

Why are EXCEL XLSM format no longer a valid ZIP format?

Files saved in Excel as XLSM files are no longer valid ZIP files, preventing editing of the Ribbon. XLSM files saved on or prior to May 23, 2014, can be renamed .ZIP and edited. XLSM files saved after May 23, 2014, cannot be renamed .ZIP and…
Pieter Geerkens
  • 11,775
  • 2
  • 32
  • 52
9
votes
2 answers

Excel External Data into a Table

I am working on an excel spreadsheet that takes data from a CSV file (produced automatically by an external system). I have used: Data->Get External Data->From Text And it works perfect ! However i am not able to format the imported data as a table…
John
  • 189
  • 1
  • 10
9
votes
5 answers

Make a custom function return nothing - not 0, not a blank string, but nothing

I have a custom function to be called from inside a spreadsheets' cell, that I want to return nothing in some cases. In other words, I want the cell with my function to be treated exactly like an empty cell (unless the function returns a value). The…
WoodenKitty
  • 6,521
  • 8
  • 53
  • 73
9
votes
4 answers

Excel formula to auto-increment after X amount of rows

I imported a few thousand rows of data into Excel and whereas one item represented one row, I've had to modify each item so that 11 rows represent the same item id. For example:- Original 63 --->data 64 --->data 65 --->data Current 63 --->data 63…
zigojacko
  • 1,983
  • 9
  • 45
  • 77
9
votes
2 answers

How to tell if an Excel 2007 spreadsheet is open and WHO has it open using VBScript

How do I tell if an Excel 2007 spreadsheet is open and WHO has it open using VBScript? I am trying to figure out whether or not an Excel workbook is currently open by another user and returning who that user is in my script. I have already figured…
Steven
  • 422
  • 1
  • 4
  • 12
9
votes
7 answers

Finding the last row of an Excel spreadsheet when the last row is hidden

I'm trying to find the last row in column A that contains a value with the following code: LastRow = DataWorksheet.Range("A:A").Find(What:="*", SearchOrder:=xlRows, SearchDirection:=xlPrevious, LookIn:=xlValues).Row This works fine for most cases,…
Slothario
  • 2,830
  • 3
  • 31
  • 47
9
votes
2 answers

Create Excel file from command line

Is there any way to create a new Excel file from command line?
Diego Pacheco
  • 193
  • 2
  • 2
  • 10
9
votes
10 answers

What is causing "Automation error Unspecified error" on Worksheet_Activate?

I have a worksheet named "Dates" (object name is A_Dates) that needs to be calculated when it is activated (It may be worth noting that this is in my Personal macro workbook). I regularly have workbooks open that have too many calculations in the…
Farfromunique
  • 447
  • 1
  • 6
  • 15
9
votes
5 answers

Excel - Button to go to a certain sheet

I'm trying to create a button to take me to my Index sheet. I know how to do it using a macro or a hyperlink, but my users aren't 'smart' users and will be calling me all day if I use macros. Does anyone know how I could solve this, besides using a…
CustomX
  • 9,948
  • 30
  • 85
  • 115
1 2 3
…
99 100