I am analyzing data in several CSV files. Everyone has the same column schema (see below). So I created the same excel file which confirms the data of the same csv file.
From time to time coming in new csv files. My idea is to copy my pre-set file excellence and give these excel files to the same name as their corresponding CSV file if I open an Excel file then I import the data from the CSV file into the same name as the existing Axle file Want to do Currently I have to manually edit the connection file in each Excel file.
I hope you understand my problem, I'm using Excel 2010
CSV schema:
Duration; MixedRatio; NumberOfObjects; NumberOfThreads; OperationTimeInterval; SingleObjectSize; type; InitialHeapSize; InitialTenuringThreshold; MaxHeapSize; MaxNewSize; MaxTenuringThreshold; NewSize; OldSize; SurvivorRatio; AVG_ALLOCATION_RATE; AVG_COLLECTION_AMMOUNT; AVG_COLLECTION_AMMOUNT_PER_MAJOR_GC; AVG_COLLECTION_PER_MINOR_GC; AVG_FREE_OLD_GENERATIOIN_AFTER_MAJOR_GC_PERCENT; AVG_FREE_OLD_GENERATION_BEFORE_MAJOR_GC_PERCENT; AVG_FREE_SURVIVOR_SPACE_PERCENT; AVG_MAJOR_GC_DURATION; AVG_MAJOR_GC_GROWTH; AVG_MAJOR_GC_GROWTH_PERCENT; AVG_MAJOR_GC_INTERVAL; AVG_MINOR_GC_DURATION; AVG_MINOR_GC_INTERVAL; AVG_PROMOTION_RATE; AVG_STOP_THE_WORLD_PER_EVENT; GC_EVENTS_NUMBER; MAJOR_GC_NUMBER; MAJOR_GC_TO_MINOR_GC; MAJOR_GC_TO_TOTAL_DURATION; MAX_STOP_THE_WORLD_TIME; MEASUREMENT_DURATION; MINOR_GC_NUMBER; TIME_SPENT_IN_MAJOR_GC; TIME_SPENT_IN_MINOR_GCS; TOTAL_ALLOCATION; TOTAL_STOP_THE_WORLD_TIME; TOTAL_TIME_IN_GCS; TOTAL_TIME_IN_GCS_PERCENT; 2; 0; 6500000, 6, 0, 100, Mixed, 6000, 15, 6000, 2000, 15, 2000, 4000, 8, 1,394,898; 1,765,219; 3,423,573; 1,570,114; 0.62153023; 0.23,56, 941; 0.0; 0.8,20,17,523; 0; 0.0; 4.6355; 0.3,04,62,942; 1.51, 23, 9 48; 29803; 0.511, 9 3, 845; 52; 13; 0.472, 9 7,874; 0.177, 99, 278; 1.38,85,045; 59.9 0,287; 39; 10.6,62,278; 11.88,05,485; 83,558,400; 26.6,20,798; 22.5424228; 0.3,76,32,2 9 8; 2; 0; 6500000, 6, 0, 100, Mixed, 6000, 15, 6000, 2250, 15, 2250, 3750, 8, 1,312,573; 1,589,237; 3,151,672; 1,728,000; 0.59, 56,703; 0.3,14, 9, 9 26; 0.0; 0.86,67,001; 0; 0.0; 4.108385; 0.3367038; 2.0222418; 60074; 0.62,22,538; 44; 14; 0.54,57,0 9 3; 0.2,00, 9 4,614; 1.45,43,015; 60.383358; 30; 12.13,802; 10.1,01,116; 79,257,600; 27.3,7 9, 166; 22.2,34, 919; 0.3,68,22, 9 24; Since the text "itemprop =" text "> after
the comment showed what I suggested that what you want Had not been there, I suggested that the removed. Perhaps you can use the following to build the name.
Enter the following formula in that cell in which you want to display the current filename with its absolute path: Name of the current worksheet: = cell ("fILENAME")
Enter only the current filename (for example, Test.xls)
To insert the name of the following formula, enter a cell in the current file: = middle (cell ("fILENAME Search ("[", cell ("filename")), search ("[", cell ("file name")) + 1 search ("]", cell ("file name")) - search )
No T If you use this formula on the worksheet not saved, you receive a #VALUE error! If you save the worksheet, the error has been replaced by the filename.
You can then use this .xls to edit and change from .csv, to be able to take action on it.
Comments
Post a Comment