Top "Worksheet" questions

Excel VBA Copy Sheet without original workbook reference

I have a routine that is copying various sheets from many workbooks and pasting these sheets in what I am …

excel vba reference copy worksheet

Excel VBA - Check if a worksheet is protected WITH A PASSWORD

We can check if a sheet is protected using ProtectContents property. But how check if it is protected with a …

excel worksheet vba

Delete a worksheet and recreate with the same sheet name

I'm currently trying to delete a worksheet and auto create a new worksheet with the same name. I'm using the …

vba excel add worksheet

Identifying worksheet index while Looping through worksheets, via getWorksheetIterator(), with PHPExcel

I'm using the PHPExcel library to read an Excel file with many worksheets and perform processing on it. Now I …

php for-loop phpexcel worksheet

How to get inline results in a worksheet in Eclipse/Scala-IDE on Ubuntu 12.04?

I've got the Scala-IDE installed on my Mac and on my pc with Ubuntu 12.04. In there I created a project, …

eclipse scala ide worksheet scala-ide

How to create new worksheets with PHPExcel using kohana 3.2

$excel2 = PHPExcel_IOFactory::createReader('Excel2007'); $excel2 = $excel2->load('ExampleSpreadsheettest.xlsx'); $excel2->setActiveSheetIndex(0); $excel2->…

php phpexcel worksheet kohana-3.2

How to delete worksheets from Excel workbook in C#?

Let's say I have one workbook which is having 6 sheets as Sheet1, Sheet2, Sheet3, Sheet4, Sheet5, Sheet6. So from here …

c# windows excel worksheet

Extract a worksheet name from the range selected

I have to input the result in the selected cell through InputBox function: Set OutputStrt = Application.InputBox("Select a cell, …

excel worksheet inputbox vba

Getting "Invalid bracketing of name" error when i try to run query on excel sheet

In order to make some reports I need to parse some excel files. When I try to select records from …

c# excel worksheet

Get Excel sheet name In SQL Server

How to get the sheet names in an Excel file using SQL Sever 2005? Please be noted that: There is no …

sql-server excel sql-server-2005 worksheet