0

hi everyone i am new to mac system, on window system we read and write data from excel sheet what about mac? if notes is an answer provide me a java code to read and write data from notes file.strong text

  • What you have tried so far? – Helping Hands Sep 2 '15 at 5:05
  • iam on search...haven't tried yet.... – sameer joshi Sep 2 '15 at 5:11
  • If you are using java and selenium webdriver then code to read/write excel would be same which you write with window OS. Mac will allow you to run same code. You might configure all things in Mac properly. – Helping Hands Sep 2 '15 at 5:13
  • Since excel works on MAC as well, you should have no issues in reading and writing data in excel files. If you have things in place (mentioned in above), you should be good. – demouser123 Sep 2 '15 at 6:09
  • This feels more appropriate for StackOverflow. However, you can still use Excel as your viewer. I don't know whether you will have the same access to the Excel object model and VBA scripting layer, since that's all based in COM on Windows. However, Excel will load Xml and CSV file formats, so try writing out data like that, and then it's both easy to code against, and editable in excel. – user3100456 Sep 2 '15 at 6:52
0

File format doesn't change no matter Windows it or Mac. I believe you need to look into Apache POI library documentation.

You can refer How to Extract Data From Files With JMeter guide for code snippets and useful links.

| improve this answer | |
0

Try to use JExcel API: http://sourceforge.net/projects/jexcelapi/files/ . And here is an example how to use it: https://github.com/amazpyel/sqa_training/tree/master/Classwork

| improve this answer | |

Not the answer you're looking for? Browse other questions tagged or ask your own question.