Home » Other » Marketplace » How to separate Excel Workbooks into new files
How to separate Excel Workbooks into new files [message #439521] Mon, 18 January 2010 02:21 Go to next message
mokdeeo
Messages: 1
Registered: January 2010
Junior Member

If you have a large workbooks that you need to separate into individual files? Do you feel boring to spliting multi-worksheet excel files into single-worksheet ones? Excel Worksheet Separator may do you a favour!

Excel Worksheet Separator is a powerful, friendly and easy-to-use Excel tool to split multi-sheet excel files into single sheet excel files with high speed. It can easy to find your excel files in seconds. Originaly change the complicated ,duplicate and boring excel work into easy one.


Step 1: Click the "add" button to add file or folder. Or right click the file list to choose you operation.



It may take you some time to scan the subfolder.


Step 2: click the combo box to mark the file. Or right click the file list to mark the selected file.


Step 3:Click the combo box to mark the sheet. Or right click the sheet list to mark the selected sheet.



You can double click the sheet in sheet list to open the excel.


Step 4:click the "split" button or right click in the sheet list to split the marked sheets or all sheets.


Then select an output folder click "ok" to continue.


It will end with opening output folder.



The button "Reload":

"Reload All Files" will refresh the file list and sheet list.

"Reload Marked File" will refresh the Marked file.



The button "Clear":

"Clear List" will delete all item in the file list and sheet list.

"Clear sheet list" will delete all item in the sheet list.



"Remove File Item" will remove file from the selected file in the file list and sheet list.

"Remove sheet item" will remove the selected in the sheet list.

For more detail,you can google Excel Worksheet Separator
Re: How to separate Excel Workbooks into new files [message #439524 is a reply to message #439521] Mon, 18 January 2010 02:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Note that this is an Oracle forum, this subforum is for Oracle questions related to Windows.
You should find better and faster answers in a windows forum.

Regards
Michel
Re: How to separate Excel Workbooks into new files [message #439545 is a reply to message #439524] Mon, 18 January 2010 04:08 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Right; but even Oracle forum is a good place to advertise your Excel software (note a powerful, friendly and easy-to-use tool sentence).

Therefore, I'll move it to Marketplace and leave as-is because I've seen quite a lot Excel-related questions in Forms forum (where people want to save form records to Excel file, and sometimes have problems with different sheets). Perhaps someone will find it useful.
Previous Topic: Interview Questions with answers available
Next Topic: Oracle Apps Technical and Functional Training (India)
Goto Forum:
  


Current Time: Thu Mar 28 11:57:23 CDT 2024