Learn More
Resend Email
12
cursee
7y

rant-ish*

PHP + jQuery + Excel
I am facing the holy trinity or something.
Cool? eh? No no, not as cool as the holy trinit holding excalibur.

One of the info is Gender : Male, Female. And they state that we must export the excel with selected gender by drawing a circle over the choice.

Not Gender : Male
But Gender : (Male) , Female

Consider my bracket as circle.

They are not even in seperate cells. So now I am spending days to draw a fucking circle over a text in excel export using php. Still failing. FML.

* I control myself from asking for coding tips here but I will appreciate anyone who can help me out regarding the issue in this rant.

rant

gfrg

getting fucked real good
Favorite
Ranter
Comments
  • 0
    7y
    So what format do they want it in eventually? Are you doing displaying the data in a web page? As a form? (in which case you would use a preselected radio button). Need a little more explanation.
  • 3
    7y
    Probablly going to be easier to just print the damn thing out, circle it by hand and then scan it back in. Still going to take less time and frustration than using PHP 😄
  • 0
    7y
    @helloworld the data are already in db. The want those data present in excel file. Like this.
  • 1
    7y
    Can you even draw a circle in an excel cell?
  • 0
    7y
    @stevenliemberg using through excel directly, yes you can. Through php or js ... that's what I am trying to find.

    My gut is telling me, no though.
  • 1
    7y
    @CurseMeSlowly
    Can’t say I’ve come across a excel library complex enough for this,

    best you could do is decompile the xlsx file to... I’m pretty sure it’s XML, and see how it creates the circles and replicate that when making from php and glue it all back together to hopefully make the xlsx file without corrupting it.

    But otherwise good luck with this. 😱
  • 4
    7y
    The logical thing to do would be to split out male and female into different cells and apply a red cell border or background colour to the male cell rather than trying to draw a shape programatically which i suspect would not be possible with php. It’s fucking stupid to use excel in the way they are suggesting. Tell them they are wankers.
  • 4
    7y
    ...but if they insist just use a composite image of the word male in an oval save it and replace the instance of the word male with the png, that should be achieveable.
  • 2
    7y
    @helloworld that's my backup plan if they cannot accept my explanation since they are wankers
  • 2
    7y
    i foresee they will say something like "i want to filter this, you fucked up"

    So the correct thing to do is to keep only one value in the cell.
  • 0
    7y
    I always try to find out why my clients want Excel.

    Then show them a better way. And if they really want it the difference in price. After that most of them don't want Excel.
  • 2
    7y
    @MisterArie you are lucky
  • 1
    7y
    @CurseMeSlowly well they worked me into a burnout before I figgured this out. So I'm not sure if I'm Lucky:D
devRant © 2021 Hexical Labs LLC
Privacy Policy  |  Terms of Service
Add Comment