- 1. Excel - Check a column for values found in another column
- / Excel /
- What? This is an article to remind me how to search a column in an Excel file for values found in another column (in this example, on another worksheet in the same workbook). How? So for demonstration ...
- Created on 14 February 2019
- 2. MS Excel - Split Workbook into separate files per sheet
- / Excel /
- ... size of about 11Mb. In order for an import process to work, the import would only accept XLS files no greater than 1Mb. So our script has to split a single spreadsheet into multiple worksheets of 3000 ...
- Created on 11 February 2019
- 3. SSIS Skip Rows in Excel Source file
- / SQL Server Integration Services /
- ... Properties panel for this. Under Custom Properties » OpenRowset, you should see the name of the Excel worksheet you specified as the datasource (eg. "Sheet1$"). Using the example above: Sheet1$A11:AL12 ...
- Created on 04 April 2013
- 4. Blank columns issue when exporting to Excel (Data Only) from Crystal Reports
- / Excel /
- ... to Excel. There are four main causes for extra blank columns to appear in a worksheet. Cause 1: Fields in the same column are not aligned with guidelines or snap-togrid To ...
- Created on 15 June 2010