1. 在数据编辑器中导入Excel文件
2. 导出Json文件,选择属性模式
3. 使用文本编辑器查看Json数据
4. 在程序中添加Json解析函数
void getJsonFromFile(const char* fileName, rapidjson::Document &jsonDict)
{
unsigned char *pBytes = NULL;
std::string jsonpath;
jsonpath = CCFileUtils::sharedFileUtils()->fullPathForFilename(fileName);
unsigned long size = 0;
pBytes = CCFileUtils::sharedFileUtils()->getFileData(jsonpath.c_str(), "r" , &size);
CCData *data = new CCData(pBytes, size);
std::string load_str = std::string((const char *)data->getBytes(), data->getSize() );
CC_SAFE_DELETE(data);
jsonDict.Parse<0>(load_str.c_str());
}
5. 获取Json文件中的数据
rapidjson::Document rapidJsonData;
getJsonFromFile("data.json", rapidJsonData);
for(int i = 0; i < 4; i++)
{
const char* name = DictionaryHelper::shareHelper()->getStringValue_json(rapidJsonData[i], "name");
int level = DictionaryHelper::shareHelper()->getIntValue_json(rapidJsonData[i], "level");
int hp = DictionaryHelper::shareHelper()->getIntValue_json(rapidJsonData[i], "hp");
int attack = DictionaryHelper::shareHelper()->getIntValue_json(rapidJsonData[i], "attack");
CCLog("%s, %d, %d, %d", name, level, hp, attack);
}
6. 程序运行结果
转载于:https://blog.51cto.com/3387980/1692305