![flowjo 10 how to export data into excel flowjo 10 how to export data into excel](https://i.pinimg.com/736x/5c/ac/5c/5cac5c6be97dd7d6f8b060332b853762.jpg)
#Flowjo 10 how to export data into excel install
Note The Northwind database is not installed when you install 2007 Microsoft Office. If you do not have the Northwind database installed on your system, you can use the Add/Remove option for Microsoft Office setup to install the sample databases.
#Flowjo 10 how to export data into excel code
If the Northwind database is located in a different folder on your computer, you need to edit the path of the database in the code provided below.
![flowjo 10 how to export data into excel flowjo 10 how to export data into excel](https://docs.flowjo.com/wp-content/uploads/sites/6/2013/03/Screenshot_102715_042240_PM.jpg)
\Program Files\Microsoft Office\Office\Samples\Northwind.mdb If you selected the default folder when you installed Microsoft Office, the database is located in: The code sample uses the Northwind sample database that is included with Microsoft Office.
![flowjo 10 how to export data into excel flowjo 10 how to export data into excel](https://docs.flowjo.com/wp-content/uploads/sites/6/2013/03/Screenshot_102215_021805_PM.jpg)
(The array is copied in one step rather than looping through each cell in the worksheet.) Then, the array is copied to an Excel worksheet through assigning the array to a range of cells. The array is then transposed so that records are in the first dimension (in rows), and fields are in the second dimension (in columns). However, if Excel 97 or earlier is detected, the recordset is first copied to an array using the GetRows method of the ADO recordset object. If Excel 2000 or 2002 is detected, the CopyFromRecordset method is used because it is efficient and requires less code. The code first checks the version of Excel. The code sample provided below shows how to copy an ADO recordset to a Microsoft Excel worksheet using automation from Microsoft Visual Basic. The sample code presented illustrates how you can transfer an ADO recordset to Excel 97, Excel 2000, Excel 2002, Excel 2003, or Excel 2007. To transfer an ADO recordset to Excel 97, you can create an array from the recordset and then populate a range with the contents of that array. However, CopyFromRecordset in Excel 97 supports only DAO recordsets. CopyFromRecordset in Excel 20 can be used to copy either a DAO or an ADO recordset. Excel 97, Excel 2000, and Excel 2002 have a CopyFromRecordset method that you can use to transfer a recordset to a range. The approach that you can use depends on the version of Excel you are automating. You can transfer the contents of an ADO recordset to a Microsoft Excel worksheet by automating Excel.