Copy Data from One Excel Spreadsheet to Another with PowerShell

re: Copy Data from One Excel Spreadsheet to Another with PowerShell

jrv — Thu, 28 Feb 2013 19:33:30 GMT

@Tae

The spreadsheet is not available for download. The scrip can be used with any spreadsheet by changing the arguments. (basic PowerShell)

re: Copy Data from One Excel Spreadsheet to Another with PowerShell

Tae — Thu, 28 Feb 2013 06:22:49 GMT

The XL 2007 spreadsheet named ApprovedUsers.xlsx (notice the mixed case name) contains over 100 names. Your Windows 2000 virtual machine never got on clearing the undo buffer during their saving rampage. How do you download this spreadsheet?

re: Copy Data from One Excel Spreadsheet to Another with PowerShell

Tae — Mon, 29 Oct 2012 15:36:50 GMT

Sheet #1 contains 2,350 names.

Sheet #2 contains the office, telephone, street, city, state and country.

The spreadsheet used in the screenshot is ApprovedUsers.xlsx.

re: Copy Data from One Excel Spreadsheet to Another with PowerShell

Tae — Mon, 22 Oct 2012 15:50:41 GMT

Screenshot #1 shows 2351 approved users in one sheet.

Screenshot #3 shows the users copied to the second sheet.

What is this name of the spreadsheet shown in the screenshots?

re: Copy Data from One Excel Spreadsheet to Another with PowerShell

Esk — Sat, 24 Mar 2012 15:22:00 GMT

You guys are way smarter than I. Probably a simple question for you, but I've wasted lots of time on this. Getting an excel spreadsheet(xlsx) via email, and I'm trying to copy and paste it into a word document. I have a Mac OSX, excel and word for mac 2011. My attempts come out garbled, 50 sheets of gibberish, or everything works except for the X%&@! last column.

Thanks so much!

re: Copy Data from One Excel Spreadsheet to Another with PowerShell

JB — Mon, 16 Jan 2012 14:56:01 GMT

This is a great post, many thanks. But I'm having issues with the cell format: the data I'm importing contains both text and numeric data. After it's been imported, everything is treated as text. Of course I could manually do the "Convert to Number" function, but this import is done automatically so no manual action need to be performed... Any idea Scripting Guy?

re: Copy Data from One Excel Spreadsheet to Another with PowerShell

JV — Mon, 21 Nov 2011 04:44:19 GMT

Your Topolgy may not match.

We have no way of knowing what F1:F$total rellay looks like.

Try posting this in an Excel foru, wher ethe users know Excel. Here - your question is kind of out-of-place. It being sometime in amuch older yea - 2010 or so.

re: Copy Data from One Excel Spreadsheet to Another with PowerShell

Scott Haan — Mon, 21 Nov 2011 03:33:53 GMT

This is not working for me. I have been using this script to try to copy from a range on one worksheet to another range in another worksheet in a seperate workbook. It works as far as copying the data, but it then pastes the data starting in the first cell of the range but goes straight down the column instead of populating the 2nd range I defined.

Here is my code:

$range = $WorkSheet2.Range("F1:F$total")

$range.copy() | out-null

$range = $item.Range("D3:BE8")

$item.paste($range)

Both the 1st range and 2nd range have the same amount of cells, 324. However when I paste into "D3:BE8" it starts at D3, but continues to go down column D instead of across row 3 to column BE, then wrap around.

Any ideas?