You want to delete an entire row and column of what? The description, "a table", is not specific enough, as it could refer to an HTML table, a table of fields in a plain text file, an Excel table, an array, or something else entirely.
As I'm sure others have suggested to you in the past: Provide provide minimal but sufficient sample input, code, and sample output. We'll take it from there in providing feedback and assistance.
| [reply] |
Output file
Reg number output
2. Correct
4. Wrong
Input file
Blank box
Blank box Reg number. Output
2. Correct
4. Wrong
The input file is starting from cell (2,2)
But I want to start from (1,1) cell. How to delete the first row and column entirely in excel file.
| [reply]
[d/l] |
In your programme, create a new worksheet and copy the current data into it as follows:
Start reading at 1,1 in the original worksheet...
...only subtract 1 from both coordinates when you write to the new one, so you achieve the goal.
After the new worksheet is done writing, delete the original,
then rename the new one with the name of the original one.
Cheers, Sören
Créateur des bugs mobiles - let loose once, run everywhere.
(hooked on the Perl Programming language)
| [reply] |
XLS or XLSX? What modules do you already use to process the Excel file?
($q=q:Sq=~/;[c](.)(.)/;chr(-||-|5+lengthSq)`"S|oS2"`map{chr |+ord
}map{substrSq`S_+|`|}3E|-|`7**2-3:)=~y+S|`+$1,++print+eval$q,q,a,
| [reply]
[d/l] |