Advertisement
Guest User

Untitled

a guest
Jul 20th, 2017
52
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.25 KB | None | 0 0
  1. cd /work_dir/
  2.  
  3. cp /source_dir/$1.XLSX /work_dir/$1.zip
  4.  
  5. unzip -p $1.zip "xl/workbook.xml" > temp.txt
  6.  
  7. count=`cat temp.txt | grep "sheet name="$2" sheetId=" | wc -l`
  8.  
  9. if [ "$count" = "1" ];
  10. then
  11.  
  12. echo "Sheet Exists"
  13.  
  14. else
  15.  
  16. echo "Sheet Doesn't Exist"
  17.  
  18. fi
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement