i need a ruby code to read the column a and find where does the last filled cell in the column ends.In the image uploaded the last filled data is i in cell "A21". i need to know this cell address through ruby code.
相关问题
- Excel sunburst chart: Some labels missing
- How to specify memcache server to Rack::Session::M
- Why am I getting a “C compiler cannot create execu
- reference to a method?
- ruby 1.9 wrong file encoding on windows
相关文章
- Ruby using wrong version of openssl
- Difference between Thread#run and Thread#wakeup?
- how to call a active record named scope with a str
- “No explicit conversion of Symbol into String” for
- Segmentation fault with ruby 2.0.0p247 leading to
- How to detect if an element exists in Watir
- Get column data by Column name and sheet name
- uninitialized constant Mysql2::Client::SECURE_CONN
try using 'spreadsheet' gem
I would do using the Ruby stdlib
WIN32OLE
.Look at the MSDN documentation of
SpecialCells
.You can get the value of
xlCellTypeLastCell
from the version ofMSExcel
installed in your pc. Just doALT+F11
->F2
-> search the constant there :