- Compares multiple XLSX or VCF files for common/different positions (intended for multisample comparison). It works like a simple file comparator, but faster.
![image](https://private-user-images.githubusercontent.com/95364352/319371939-827da7fe-86d4-4892-a0e4-72b9346ca734.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjExOTEwNTksIm5iZiI6MTcyMTE5MDc1OSwicGF0aCI6Ii85NTM2NDM1Mi8zMTkzNzE5MzktODI3ZGE3ZmUtODZkNC00ODkyLWEwZTQtNzJiOTM0NmNhNzM0LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA3MTclMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwNzE3VDA0MzIzOVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTY5OTdlNDUxZjc4NzlkY2Q4ZDBlYzE5MDc2YzJiMTUyYmZiZjQxZWI2OGE5Y2U2YWM1NGRlNmRlZWVmMGU1ZjImWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.TPFt3qXMHTWbPt8C0gR3h3TLtMyGymv5vJEW7hYV234)
Compares multiple XLSX files for common/different positions (Suitable for every use. Fast and reliable. Engineered for multisample comparison)
- Add at least 2 XLSX Excel files by clicking
Add file
button (there is no file number limit) - Change
FCHR
&ACHR
of every file!- FCHR: First Cell of the Categories row. Find your headers row, (usually the first row) write the first cell's value here (most left cell).
- ACHR: Aimed Cell of the Categories row. Find your headers row, find the column you want to compare, write the header of that column here.
- If desired, you can:
- change your pre-selected
Output folder
- name your new Excel file
Output file (.xlsx)
- mark/unmark
Split cell text
or add your custom splitter - mark/unmark
Output the differences
(check this if you need discordant comparison)
- change your pre-selected
At last an Excel (.xlsx) file will be created in chosen output folder with multiple spreadsheets containing common positions of XLSX files. If Output the differences
checked, each spreadsheet will have it's own differences.
- Input file name mustn't contain illegal characters like
.
:
or'
. Otherwise, program will crash. - You should fill
FCHR
&ACHR
cells correctly, these are case-sensitive. Otherwise, program will crash. - All files should be in Excel Workbook ".xlsx" format (not .xls or not
Strict Open XML Spreadsheet
as it has the same suffix .xlsx) - First rows of XLSX files are allowed to have metadata starting with "##". If they don't exist, it's perfect. (As these kinds of files mostly get converted from a VCF file to Excel, they tend to have "##" rows)
- Numbers under the positions column may have String values to make reading more easy (like 132.681). In that case, cell will be read as an integer value.
- There mustn't be a highlighted/edited cell in a row under the final row. (For example, last row is row number 351, you accidently highlighted row 462. Algorithm thinks there are more data between those, therefore it crashes.
Compares multiple VCF files for common/different positions (for multisample comparison)
(Faster than XLSX Comparator)
- Add at least 2 VCF (Variant Call Format) files by clicking
Add file
button (there is no file number limit) - Change
FCHR
&ACHR
of every file!- FCHR: First Cell of the Categories row. Find your headers row, (usually the first row) write the first cell's value here (most left cell).
- ACHR: Aimed Cell of the Categories row. Find your headers row, find the column you want to compare, write the header of that column here.
- If desired, you can:
- change your pre-selected
Output folder
- name your new Excel file
Output file (.xlsx)
- mark/unmark
Split cell text
or add your custom splitter - mark/unmark
Output the differences
(check this if you need discordant comparison)
- change your pre-selected
At last an Excel (.xlsx) file will be created in chosen output folder with multiple spreadsheets containing common positions of VCF files. If Output the differences
checked, each spreadsheet will have it's own differences.
- Input file name mustn't contain illegal characters like
.
:
or'
. Otherwise, program will crash. - You should fill
FCHR
&ACHR
cells correctly, these are case-sensitive. Otherwise, program will crash. - It is assumed that first rows are metadata for VCF file, which start with "##". If they don't exist, it is no problem.
- Numbers under the positions column may have String values to make reading more easy (like 132.681). In that case, cell will be read as an integer value.
- It's the best if you don't alter/change/touch the VCF file before processing it, to make sure a potential error is not your doing.
Click the gear icon on the top right corner, next to the (i) button. It will open a DevConsole window. There you can see every operation done. As there is no progress bar and sometimes program gets stuck due to faulty files, open dev console and see it with your eyes, if your file is being processed.
App icon by: Healthcare and medical icons created by Muhammad_Usman - Flaticon