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

closed as off-topic by Niels van Reijmersdal, Kate Paulk, Ethel Evans, corsiKa Sep 8 '15 at 7:17

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions about software development unrelated to testing are off-topic here, but can be asked on Stack Overflow." – Niels van Reijmersdal, Kate Paulk, Ethel Evans, corsiKa
If this question can be reworded to fit the rules in the help center, please edit the question.

  • 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.

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

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