Results 1 to 2 of 2
  1. #1
    JetLagFox is offline Member
    Join Date
    Jan 2017
    Posts
    21
    Rep Power
    0

    Default Doubts with Excel and phpmyadmin

    Hi everyone,

    I have some questions about how to import an Excel to phpmyadming:

    1.- As I have read, once I have the Excel created I have to saves it as .csv, but the problem I find is that in this type of field the columns are separated with commas, and I find it a problem because one columns is a descripción (a large text) which has commas...is there any way to skip this problem?

    2.- The Excel is created with an scraping method, but I have to add at least two columns to the Excel. I know that I can do it manually but...it's an Excel that will be updating everyday, do I have to introduce the data manually everyday? at this point I find also another problem, now I have almost 3.000 rows, and if more games are added to the webpage I am scrapping, the amount of rows will be different, and the new game or games will be added anywhere. I don't know how to deal with this problem.

    3.- Once the first Excel created, I would like to revise if there are changes in the prices, and if there are, update the Excel cell and mark it with a green color (for example). Is there any way to do this? do I have to do it with Java?

    Thanks in advice,

    Have a good day.

  2. #2
    SurfMan's Avatar
    SurfMan is offline Godlike
    Join Date
    Nov 2012
    Location
    The Netherlands
    Posts
    1,993
    Rep Power
    9

    Default Re: Doubts with Excel and phpmyadmin

    1) Make Excel export to CSV using quoted values.
    2a) Use Apache POI to modify the Excel sheets
    2b) read all the game titles in a separate gamestructure, compare this to the values in the Excel sheet, update where necessary.
    3) Apache POI allows for setting cell styles. Example here.

    Note: editing a CSV file with Excel does not make it an Excel file. CSV is text, so it does not support colours and other fancy stuff. Updating that with POI is also not possible.

    Edit: Where does phpmyadmin fit in in all of this?
    Last edited by SurfMan; 01-16-2017 at 06:04 PM.
    "It's not fixed until you stop calling the problem weird and you understand what was wrong." - gimbal2™ © 2013

Similar Threads

  1. Using phpmyadmin with Netbeans mysql server
    By xlactyu in forum NetBeans
    Replies: 0
    Last Post: 10-02-2016, 01:00 PM
  2. Few Doubts
    By sunnyboy in forum New To Java
    Replies: 0
    Last Post: 03-10-2011, 02:55 AM
  3. jdbc connection with phpmyadmin
    By anand_fevi in forum JDBC
    Replies: 2
    Last Post: 05-19-2010, 02:45 PM
  4. scjp doubts
    By vijay24805 in forum Java Certification
    Replies: 0
    Last Post: 03-24-2009, 09:27 PM
  5. Applet doubts
    By anithababu in forum Java Applets
    Replies: 0
    Last Post: 01-18-2008, 06:09 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •