worksheet_开发者

Copy sheet and get resulting sheet object?

Is there any easy/short way to get the worksheet object of the new sheet you get when you copy a worksheet?[详细]

2023-04-11 18:36 分类：问答

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 front-end (C#, VB, PHP, etc.);[详细]

2023-04-05 18:50 分类：问答

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.[详细]

2023-04-05 01:31 分类：问答

How can I join Excel documents using PHPExcel?

I\'m using PHPExcel to dynamically generate order receipts. I\'d like to be able to generate a \"summary\" Excel 开发者_Python百科file, containing all the order receipts (one per worksheet).[详细]

2023-04-02 16:23 分类：问答

Excel Macro: conditional cut and paste between workbooks

So I want a macro running in an Excel file (\"input.xls\") that is searching a column in another Excel file (\"data.xls\") for the value \"1\" (the only values in that columns are 1s and 0s). When it[详细]

2023-04-01 15:33 分类：问答

Excel macro parse data from multiple worksheets (with worksheet names)

I\'ve searched around a bit, but haven\'t been able to find a solution to this exact issue. All the other threads about copying data from multiple worksheets that I was able to find were looking to co[详细]

2023-04-01 02:01 分类：问答

Oracle sql worksheet

I\'m trying to compare 2 columns and the goal is the return of the lines that don\'t match. For example I have in column 1 and 2 the following[详细]

2023-03-27 04:52 分类：问答

Can't copy a Worksheet that contains a Chart using EPPLUS

I\'m trying to copy a worksheet that contains a chart, but when I try to do it, my code fires a \"package relationship with specified id does not exist for the source part\" exception, what are possib[详细]

2023-03-18 22:40 分类：问答

moving from one csv worksheet to the next in a python script

I\'ve been using excel to create .csv workesheets that I\'d like to parse using python. Each worksheet is named after a shop (e.g worksheet 1: \"Waitrose\", worksheet 2: \"Tesco\", worksheet 3: \"Asda[详细]

2023-03-08 16:01 分类：问答

Search multiple worksheets and copy all rows with a where column A is >0 to a specified worksheet

Greetings, I\'ve looked quite a bit fo开发者_JAVA技巧r code to help me do this, and though I\'ve found several pieces that hint around it, maybe it\'s my inexperience with vba, but I haven\'t been ab[详细]

2023-03-07 17:24 分类：问答