Assuming excel is required, the following 36 results were found.
-
this article will help you more than my search engine skills do. My Setup Windows XP Workstation...needs to open... Excel 2007 SP2...with ODBC to... MySQL v5+...hosting database... ActivityLog...contains activity, staffID, resourceID, start time,...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Situation I have a Microsoft Excel 2007 file that connects to a SQL Server 2008 R2 database. The Excel file pulls data using lookup tables and displays the data in an Excel Spreadsheet. The Problem We can select all cells and set row height to be 30 for...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
article serves to explain how to split a spreadsheet consisting of multiple sheets into separate files per sheet. Why? The Excel file in question was about 36000 rows and had a file size of about 11Mb. In order for an import process to work, the import...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
A quick article on how to skip rows or even specify a range to extract from the Excel file when using as the DataSource. Why? If you are simply using a text file as your data source, then the options in the connection manager will let you skip rows and...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
Following up on my article on correcting disappearing headers, a further issue with our web-report is that even an export to Excel (Data Only) from Crystal Reports 9, created extra columns. This issue could not be replicated on the client machine (ie....
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
This is a quick article on how to convert some cells in Microsoft Excel to number values... Why? OMG. Seriously Microsoft! I have spent an hour trying to convert a column of currency values to a number using Microsoft Excel 2010. Since when did MS Excel...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
This is a quick reminder for myself on opening a CSV in MS Excel but without converting long numbers into exponential notations (which are incorrectly rounded anyway). My Data: Account ID,Name,Phone,Record ID...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
If you've been to the point where you're exporting a report to Excel, and only some of the column headers appear, then try this: I googled this for ages and found different suggestions here and there but none of them produced consistent results. One...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
I have: A CSV file exported from Excel along with double-quotes label1,label2 item1a,item2a item1c,"item2c,c" item1b,item2b What I want: To read the file (stored on the server) and convert to a JavaScript array of objects var my_object_array = [ {...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
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 purposes, I'm using a new Excel file with two worksheets...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
We have an excel spreadsheet which reports against a mySQL database and reads time spent on projects by IT Service colleagues. The main report is a pivot table with staff members along the top, tasks down the first column, and time spent in the form of...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
A quick article on if you want to extract the link from some text you have copied off the web and into an MS Excel document. How? Open up a new workbook. Get into VBA (Press Alt+F11) Insert a new module (Insert > Module) Copy and Paste the Excel user...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
of solutions out there, none of which applied to what we meant and lots of people in the same boat. The Situation We have an Excel report which summarizes for our guys at the top, all the activities and time spent by staff. There are several filters...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
a quick way to see what values are in the old column and which ones are new... Why? Consider the 3 following columns in an Excel spreadsheet: Old New Exists in Old? --------- --------- -------------- 123456 234567 234567 345678 345678 456789 567890...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
116 42 30 E 39.81111111 116.708333333 39.81111111 116.7083333 Note that negative numbers should be supported. I tend to use Excel to reduce the decimal point to only 7 decimal places (for importing to a database where DECIMAL(10,7) ). Merging the lot If...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
note to myself so that I never use parentheses in the column headings again. Basically I have a pivot table in Microsoft Excel 2010 with the projects down the left (in the first column) and the days of the week along the top. Why? The excel report would...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
Excelhttps://joellipman.com/articles/microsoft/excel.html
- Type: Category
- Language: *
-
Thought I'd put a quick note here, I tried a fair few solutions that didn't work and then found this hidden away in a forum: Quick Count =INT(SUMPRODUCT((A3:A1000"")/COUNTIF(A3:A1000,A3:A1000&""))) This returns the number of unique values in the range...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
To: MS SQL Server 2008 R2 MS Windows 7 Enterprise (Client) MS Excel 2010 What? A really quick note on how to insert a carriage return or new line into the column name/alias (the header). It might seem trivial but these little aesthetic changes done at...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
selected (I'd tick most of the fields this contains) Create a data table in ZohoAnalytics to hold the attachments Create an Excel spreadsheet or CSV file with the headers: Ticket ID, Attachment ID, Image URL, Created Time, Modified Time Add a dummy row...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *