Re: [python-win32] XLSM to CSV/XLS conversion
On Wed, Oct 18, 2017 at 9:44 AM, sridhar vr wrote: > > Anyone can tell me, how I can convert XLSM to CSV/XLS using python. > I'm assuming you actually specifically mean XLSM. An Excel application dispatch object will have what you seek for evaluating in-cell VBA and the rest is just wrangling with security settings and following MSDN documentation. -- Joni Orponen ___ python-win32 mailing list python-win32@python.org https://mail.python.org/mailman/listinfo/python-win32
Re: [python-win32] XLSM to CSV/XLS conversion
sridhar vr wrote: > > Anyone can tell me, how I can convert XLSM to CSV/XLS using python. Not sure what you mean by CSV/XLS. It's quite useful to convert XLSX to CSV, but I don't know why you'd want to automate XLSX to XLS conversion. For XLSX to CSV, there are two basic paths. One is to use COM to control Excel itself, load the file, and do the save. That's not too many lines of code, but it requires that you have Excel installed, and it takes time to launch the app. The other path is to use one of the existing Python packages to read Excel files directly. like openpyxl. Check the list here: http://www.python-excel.org/ -- Tim Roberts, t...@probo.com Providenza & Boekelheide, Inc. ___ python-win32 mailing list python-win32@python.org https://mail.python.org/mailman/listinfo/python-win32
[python-win32] XLSM to CSV/XLS conversion
Hi, Anyone can tell me, how I can convert XLSM to CSV/XLS using python. Best Sridhar ___ python-win32 mailing list python-win32@python.org https://mail.python.org/mailman/listinfo/python-win32