Can you please advise for any script in unix such that for example , i have 3 different excel sheet at the location /ppt/gfr/exc so the name s of the excel sheet are
now in these 3 different excel sheet there is lot of data for example each excel sheet contain 100 rows , now i want such a script in unix that will create another excel shee
I am wondering how do i program it in a way that whenever i run a exe and there will be a user prompt to select either an excel sheet or data from a table within the excel sheet and import the information into a table in SQL Server 2008 and from there i can prompt user to select the data table that they want and export into another excel sheet
1) User runs .exe file
2)Prompts user to se
Need Unix Shell Script .KSH for saving my job :(
I need an urgent help for automating Data Validation which includes Data Type Check, Column validation between source and Target Table.
Have to give input in Excel sheet.csv,column A,B,C,D refers to Column in Excel sheet.
Column A Column B Column C Column D
DB_NAME_SRC TABLE_NAME_SRC DB
I have an Excel workbook with two sheets: a PowerView sheet and a PowerPivot sheet. They both show the same data; the PowerView sheet shows data at a high level, and the PowerPivot allows users to filter and drill down into details. What I'd like to do is allow users to specify filters on the PowerView sheet that then get applied to the PowerPivot sheet.
I have two (and sometime more than two) different files in excel 2007 from which i need to extract data based on some criteria and paste the filtered data to another excel sheet. I was looking for some VBA code which can help me do this.
i want a Macro to crete a exel file with data from another excel file. for ex if an excel file A contain 2 sheets (sheet1 and sheet 2). i must get the data from sheet 1 and sheet 2 to form a new excel document with the data in single sheet. Please help me.