export function transformToStr(i:number):string {//excel单元格数字转AAA
var s = "A B C D E F G H I J K L M N O P Q R S T U V W X Y Z";
var sArray=s.split(" ");
const map = new Map()
sArray.map((item,index)=>{
map.set(index+1,item)
})
let ArrStr:number[] = []
function setArr(num:number,arr:number[],i:number):void{
const shi = Math.floor(num/26);//十位
const ge = num % 26;//各位
arr[i] = ge;
if(shi > 26){
setArr(shi,arr,++i)
}else{
if(ge === 0){
arr[i+1] = shi - 1;
}else{
arr[i+1] = shi;
}
}
}
setArr(i,ArrStr,0)
let result:string = ''
ArrStr.reverse().map((item,i)=>{
if(i === 0 && item === 0){
result +=''
}else{
if(map.get(item)){
result += map.get(item)
}else{
result +='Z'
}
}
})
return result
}
export function strToNamber(str:string):number {//excel单元格AAA转数字
var s = "A B C D E F G H I J K L M N O P Q R S T U V W X Y Z";
var sArray=s.split(" ");
const map = new Map()
sArray.map((item,index)=>{
map.set(item,index+1)
})
if (str.length == 1){
return map.get(str)
}else{
const strList=str.split("");//AA
let num = 0
strList.forEach((item,index)=>{
if(strList.length - 1 === index){
num+=map.get(item)
}else{
// num+= map.get(item)*(strList.length - index - 1)*26
num+= map.get(item)*Math.pow(26,strList.length - index - 1)
}
})
return num
}
}