C++ 代码：电子表格坐标转换

{"title":"C++ 代码：电子表格坐标转换","description":"使用 C++ 语言编写程序，实现电子表格坐标 (例如: BC23) 与 RXCY 坐标 (例如: R23C55) 之间的转换。","keywords":"C++, 电子表格, 坐标转换, Excel, RXCY, 程序","content":"#include "iostream"\n#include "string"\n#include "sstream"\n\nusing namespace std;\n\n// Function to convert Excel column number to column name\nstring convertToColumnName(int columnNumber) {\n string columnName;\n \n while (columnNumber > 0) {\n int remainder = (columnNumber - 1) % 26;\n columnName = (char)(remainder + 'A') + columnName;\n columnNumber = (columnNumber - 1) / 26;\n }\n \n return columnName;\n}\n\n// Function to convert Excel column name to column number\nint convertToColumnNumber(string columnName) {\n int columnNumber = 0;\n int power = 1;\n \n for (int i = columnName.length() - 1; i >= 0; i--) {\n columnNumber += (columnName[i] - 'A' + 1) * power;\n power *= 26;\n }\n \n return columnNumber;\n}\n\n// Function to convert RXCY format to Excel format\nstring convertToExcelFormat(string coordinate) {\n stringstream ss(coordinate);\n string row, column;\n getline(ss, row, 'R');\n getline(ss, column, 'C');\n \n int columnNumber = stoi(column);\n string columnName = convertToColumnName(columnNumber);\n \n return columnName + row;\n}\n\n// Function to convert Excel format to RXCY format\nstring convertToRXCYFormat(string coordinate) {\n string row, column;\n \n for (int i = 0; i < coordinate.length(); i++) {\n if (isalpha(coordinate[i])) {\n column += coordinate[i];\n } else {\n row += coordinate[i];\n }\n }\n \n int columnNumber = convertToColumnNumber(column);\n \n return "R" + row + "C" + to_string(columnNumber);\n}\n\nint main() {\n int n;\n cin >> n;\n cin.ignore();\n \n for (int i = 0; i < n; i++) {\n string coordinate;\n getline(cin, coordinate);\n \n if (coordinate[0] == 'R' && isdigit(coordinate[1])) {\n cout << convertToExcelFormat(coordinate) << endl;\n } else {\n cout << convertToRXCYFormat(coordinate) << endl;\n }\n }\n \n return 0;\n}\n"}